Joining text from 2 cells

  • 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.

  • Try the Concatenate function.

    For example in you have City in cell A1 and State in B1 in cell C1 type:


    Hopefully that is what you are looking for.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!