software

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'

=A1amp;quot; quot;amp;B1

and copy down

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;McGreal55quot; gt; wrote in message
...
gt; I have a large spreadsheet, that has first name in one column, then
surname
gt; in second column and I need to combine the two names into one column, so I
gt; can import it into Access as 'contact name'
If Lastname were in B1 and Firstname in A1, and you wanted a result of
quot;Lastname, Firstnamequot; then use =B1amp;quot;, quot;amp;A1 in a helper column and copy down.

Vaya con Dios,
Chuck, CABGx3
quot;McGreal55quot; wrote:

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