Thanks:  0
Likes:  0

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?

2. Try

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

3. 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•