| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting out cell contents
I have a column of cells containing 'Lastname,FirstName MI'. I'd like to
split this into 3 columns to better utilize in a mailmerge. Any help is much appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
splitting out cell contents
This returns Lastname
=LEFT(A1,FIND(",",A1,1)-1) This returns Firstname =MID(A1,FIND(",",A1,1)+1,LEN(A1)-2-FIND(",",A1,1)) This returns MI =RIGHT(A1,1) Vaya con Dios, Chuck, CABGx3 "ksh" wrote: I have a column of cells containing 'Lastname,FirstName MI'. I'd like to split this into 3 columns to better utilize in a mailmerge. Any help is much appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
splitting out cell contents
Data/ Text to Columns
Delimited by comma and space. -- David Biddulph "ksh" wrote in message ... I have a column of cells containing 'Lastname,FirstName MI'. I'd like to split this into 3 columns to better utilize in a mailmerge. Any help is much appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting cell contents | Excel Discussion (Misc queries) | |||
| Splitting cell contents | Excel Discussion (Misc queries) | |||
| Splitting the contents of a cell | Excel Discussion (Misc queries) | |||
| Splitting the contents of a cell? | Excel Worksheet Functions | |||
| Splitting Cell Contents with a comma | Excel Worksheet Functions | |||
Hybrid Mode
