combining fields/columns

[JAFT]

this is probably an extremely simple thing, but I can't find the
answer...
I am trying to combine columns (i.e. I have a spreadsheet which has
columns for first & last names, which I want to combine into one field)

using excel 2004 for mac
thanks

 

[Domenic]

Assuming that Column A contains the first name, and Column B contains
the last name, try the following...

C1, copied down:

=A1&" "&B1

....for John Smith, or...

=B1&", "&A1

....for Smith, John

Hope this helps!

 

[JE McGimpsey]

To do it in place...

http://www.mcgimpsey.com/excel/subs/mergedata.html