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
Comments
-
Try
=Left(City1, 3) + Number1
OR if your join actually worked, you can also try this...
=Join(Left(City1, 3) + Number1)
-
Thank you very much!