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
 
Back
Top