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" wrote:

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

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

On Thu, 2 Nov 2006 15:16:02 -0800, Molly
wrote:

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