splitting out cell contents

K

ksh

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.
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combination of text in 2 columns 4
Split column contents (de-concantenate) 7
convert column to row 2
separating cells with text 1
Need Excel formula to separate names into columns, with exceptions 4
Color formatting in cell $An 3
I have a Comma Delimited FIle that requires 10 characters for name 4
Need help setting up weekly mail-merge format 1

Top