Merging Two Columns Containing Names

[Steve]

Hi all,

I need to merge two columns (first name and last mane),
how can I do this?

Example:

abc def
abc def
abc def

abc def
abc def

Thanks,

Steve,

 

[Cutter]

Assuming you have your first names in col A and last names in col
place this formula in col C and copy down as far as you need it:

=A1&" "&B

 

[Max]

=A1&" "&B1

Perhaps just wrap a TRIM() around the above
to clean up any stray leading / trailing spaces
in the inputs in cols A and B

: =TRIM(A1&" "&B1)