Merge three columns in spreadsheet to create one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a name data base w/ three columns I want to make into one: First name,
Last name, and spouse first name. I need to merge into one column that has
all three names in it.

Example of Merged data:
Fred & Wilma Smith
 
In the column where you want all the data, use the concatenate formula.

ie in cell A2 type =concatenate(b2, c2, d2) and it will bring the three
fields into the one column

Nick
 
Molly

Are you sure you want to do this?

Having all three items in one cell will make it very hard to sort or filter.

Most programs that interface with Excel require the fields to be separate.

Assuming col A has Fred, col B has Smith and col C has Wilma

In D1 enter =A1 & " & " & C1 & " " & B1


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging multiple columns into one column (dynamically) 1
Eliminating extra spaces in mail merge with Excel/Publisher 2
Spilting a column 6
merging multple columns into one column (dynamically) 2
Trying to merge data from mulitple rows to one. 1
Merge Columns 3
Combining Columns keeping only one value 3
how to merge data from multiple columns to one column 5

Back
Top