Merging Two Columns Containing Names

  • Thread starter Thread starter Steve
  • Start date Start date
S

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,
 
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
 
=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)
 
Back
Top