MS Excel question, merging 2 fields with text

furman · 5 Mar 2007 at 18:31

Hi,
I have a small customer table with 500 records. For some reason I decided to split the name into First name and Last name but now I want to join them. I have seen this page http://office.microsoft.com/en-gb/excel/HP012163991033.aspx#MergeCellContents but I don't quite know how to implement it. I have my data in table ref D4 and E4, I enter the formula in D3 and try to copy it down and it just shows 0. Any advice please.

TriedandTested · 5 Mar 2007 at 18:43

I've done this before, and i believe it's the '&' character you use instead, for example, the '+' symbol if you were adding two numbers.

Hope that helps..hard to explain...

=A1&A2 put this in A3 to test.

DAS · 5 Mar 2007 at 18:49

Tried&Tested said:
I've done this before, and i believe it's the '&' character you use instead, for example, the '+' symbol if you were adding two numbers.

Hope that helps..hard to explain...

=A1&A2 put this in A3 to test.

That'#s correct but you may want a space between the names in which case you would do:

D4 & " " & E4

Origin · 5 Mar 2007 at 19:14

I do this using the Concatenate function.
Cell A1 = First name Cell B1 = second name
In C3 Type "=concatenate(A1,B1) and then they will be joined together, if you need a space then it must be in one of the cells. You could make a third column with a space in it (in the middle) and concatenate them all.