Joining 2 columns

Patricia Worth

Hi, i need to join 2 columns. First column is the City Name and second is the Numbers. I got it to work but I only need the first 3 digits from the City : =JOIN(City1 + Number1) comes out CITYNAME3462

I need to show up CIT3462

thank you for the help

Mike Wilday

Try

=Left(City1, 3) + Number1 

OR if your join actually worked, you can also try this... 

=Join(Left(City1, 3) + Number1)

Patricia Worth

Thank you very much!