Help combining names

nikita2471 · Apr 23rd, 2002, 11:09 AM

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 · Apr 23rd, 2002, 11:12 AM

Try

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

Aladin Akyurek · Apr 23rd, 2002, 11:13 AM

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 11:09 AM	#1
nikita2471 New Member Join Date: Apr 2002 Posts: 1	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?

Apr 23rd, 2002, 11:12 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Try =CONCATENATE(B1," ",C1," ",D1) or =B1 & " " & C1 & " " & D1 in A1 and copy down (both do same thing)