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.
Don’t have an account yet? Register yourself now and be a part of our community!