splitting out cell contents

  • Thread starter Thread starter ksh
  • Start date Start date
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.
 
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
Text to Columns Problem 4
separating cells with text 1
HELP! Split cell contents to new rows 7
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells 1
Splitting data in cells 2
Split column contents (de-concantenate) 7
convert column to row 2

Back
Top