Combining two columns with text problem

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hi
I have a database (MS Office/Excel 2003) which lists all my contacts details
in, which I'm trying to import into BCM. I have imported everything ok
except for one slight problem....in Excel I have two columns for my contacts
names, ie one column for First Name and one column for Surname. I need to
combine both these two columns into one which will give the both first name
and surname under one column. How can I do this in Excel?
Thanks
Simon
 
Simon

Use a helper column alongside your data.
If you have "John" in A1 and "Smith" in A2, in A3 put

=A1&" "&A2

This will give you "John Smith"

Andy
 
Thank you...much appreciated Andy
Simon

Andy B said:
Simon

Use a helper column alongside your data.
If you have "John" in A1 and "Smith" in A2, in A3 put

=A1&" "&A2

This will give you "John Smith"

Andy
Click to expand...
 
Try this
Column A Column B Column C
XXXX yyyyy =A1&""&B1

(do a column copy paste) that will automatically change
cell reference for each row.

Then delete make a copy of file and delete Column A &B in
new copy.
Good Luck
 
You can also use the concantenate function. Click on an
empty cell, then choose concantenate from your functions.
When the function wizard appears, click on the first
field, and then choose the column with the name you want
to appear first, then in the second field, click on the
name you want to appear second in the cell. When you're
finshed you will have both names in one column. You can
then copy the formula down your list.
 
Back
Top