Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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' |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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' |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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' |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TEXT TO COLUMNS WITH LEADING ZEROS | Excel Discussion (Misc queries) | |||
Text to columns | Excel Discussion (Misc queries) | |||
Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Text To Columns | Excel Worksheet Functions |