Thread: How do I combine two columns of text to 1 as in 1st name surname
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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'


Reply With QuoteReply With Quote