How do I combine two columns of text to 1 as in 1st name surname

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large spreadsheet, that has first name in one column, then surname
in second column and I need to combine the two names into one column, so I
can import it into Access as 'contact name'
 
=A1&" "&B1

and copy down

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
If Lastname were in B1 and Firstname in A1, and you wanted a result of
"Lastname, Firstname" then use =B1&", "&A1 in a helper column and copy down.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top