| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatonate - can it be undone
I need to split first and last name into two fields/columns - is there a
macro or formula that could accomplish this? Thanks. Rita |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatonate - can it be undone
=LEFT(A1,FIND(" ",A1)-1
=MID(A1,FIND(" ",A1)+1,255) replace the " " by ", " if you separate with a comma. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Rita" wrote in message ... I need to split first and last name into two fields/columns - is there a macro or formula that could accomplish this? Thanks. Rita |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatonate - can it be undone
Data-Text to columns then choose delimited and put a check next to what is
in between the names and it will split them into columns. -John "Rita" wrote: I need to split first and last name into two fields/columns - is there a macro or formula that could accomplish this? Thanks. Rita |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatonate - can it be undone
thanks to you both!
Rita "Bob Phillips" wrote: =LEFT(A1,FIND(" ",A1)-1 =MID(A1,FIND(" ",A1)+1,255) replace the " " by ", " if you separate with a comma. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Rita" wrote in message ... I need to split first and last name into two fields/columns - is there a macro or formula that could accomplish this? Thanks. Rita |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatonate and Substitute show the formula rather than the result | Excel Worksheet Functions | |||
| Way to Concatonate cells in a row based on the order they were entered? | Excel Worksheet Functions | |||
| concatonate | Excel Discussion (Misc queries) | |||
| Concatonate | Excel Discussion (Misc queries) | |||
| huge amount of text in merge cell - want undone! | Excel Discussion (Misc queries) | |||
Linear Mode
