I have 1 column of 2000 rows.  Each row consists of a person’s name; street address; city, state, and zip code.  Thus far, I’ve gone to the “Data” tab then “Text To Columns” used the “Delimited” option to delimit by “Space.” That option has seperated the text within each row into seperate cells.  How do I combine the cells to combine,for example, first name with last name, house number with street name, and so on?

You can use the “&” key which is a substitute for concatenate. Assuming that your first name and last name is in A1 and B1 respectively, you can combined them together (with a comma in between them) using the following formula:

=A1&”, “&B1

Leave a Reply