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

[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'

 

[Bob Phillips]

=A1&" "&B1

and copy down

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Guest]

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