Help combining names

[nikita2471]

I have names in 3 separate columns,...B, C and D. I want to combine all 3 and place into column A. B is first name, C is middle name and C is last name. I have over 2500 names. I want all the names in Column A combined. (I hope this is making sense) Can't seem to figure out the formula for this. Any suggestions?

 

[AJ]

Try

=CONCATENATE(B1," ",C1," ",D1)
or
=B1 & " " & C1 & " " & D1
in A1 and copy down
(both do same thing)

 

[Aladin Akyurek]

On 2002-04-23 10:09, nikita2471 wrote:
I have names in 3 separate columns,...B, C and D. I want to combine all 3 and place into column A. B is first name, C is middle name and C is last name. I have over 2500 names. I want all the names in Column A combined. (I hope this is making sense) Can't seem to figure out the formula for this. Any suggestions?

In A2 enter:

=B2&" "&C2" "&D2

Give a double click on the little black square in the lower right corner of cell A2 in order to copy down.