In column A I have the names of cities. In column B I have the name of the respective state. I want to merge these 2 columns into 1 column and have the city separated from the state with a comma like this "City, ST". I know how to use the text to columns but this would be like the reverse. Any help would be great.
Joining text from 2 cells
-
-
Try the Concatenate function.
For example in you have City in cell A1 and State in B1 in cell C1 type:
=CONCATENATE(A1,",",B1)
Hopefully that is what you are looking for.
-
and if you can't be bothered to write CONCATENATE just use
=A1 & "," & B1
-
pretty well answer
HI!
pretty well answer has been given to you already.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!