Microsoft Excel - combine columns

Question

I have 'Mr. & Mrs.' in one column, and 'Smith' in the next column. This travels down 2000 rows with various titles and last names. I want to combine these two columns into one column, reading 'Mr. & Mrs. Smith'. How do I do this?

abach · Answer

You can use the concatenate function. Or, if you prefer, just enter the following in a cell.

If A1 contains Mr. and Mrs. and A2 contains Smith, then enter =A1 & " " & A2 in cell A3 to see Mr. and Mrs. Smith. (Note there is a space between the double quotes)

jpmmjm · Answer

I did find the concatenate function, and I was able to combine the two columns into one. (to get a space between the two columns, I inserted a column with just a space in it to include in the concatenate function). Now -- I need to save this as text in this new column, but when I try format/cells/text-it does not convert the concatenate function into text. What am I doing wrong?

abach · Answer

Select the range and choose Copy. Then, choose Edit, Paste Special, and choose Values.

jpmmjm · Answer

Allan, It worked! Thanks very much for your help. jpmmjm

Productivity Software

Microsoft Excel - combine columns

Was this post helpful?