Merge columns

  • Thread starter Thread starter Jonesy
  • Start date Start date
J

Jonesy

I have a spreadsheet that looks like the following:
A B
1 Last Name First Name
2 Jones Jim
3 Smith Bob
4 Williams Joe

If the formatting doesn't come over, it is a spreadsheet
with two columns (Last Name and First Name) that need to
be merged into one column that is just called Name. The
data from both columns must merged also. The merge and
center button merges the cells into one, but drops off
half of the data. Is there any way to do this?
 
Jonesy, try this in C2 =A2&B2 or this with a space =A2&" "&B2 and copy down

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Back
Top