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

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'

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

=A1&" "&B1

and copy down

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"McGreal55" wrote in message
...
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'

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

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



"McGreal55" wrote:

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'