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.

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.

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.