Question on breaking on cell into three seperate

F

Frank Sabella

I am currently searching for a method to do a similar formula in excel.

I currently process around 120 students every 2 weeks into classroom databases. Currently when we recieve the spreadsheet, the names of students show as:
last, first middle initial in cells A1-A120.

I was wondering if there was a way to create a formula to break this cell down into three cells one for first, one for last and one for middle inital.

Example...

Smith, John C.
would be in cell A1

How could this be broken down into three seperate cells B1, C1 and D1?

I tried basing this off the above suggestions but peoples name have different lengths so I need a way to seperate them by commas and periods. any suggestions would be appreciated. Thanks
 
D

David Biddulph

Data/ Text to Columns/ Delimited/ by comma and by space (and add a period in
the other box, if you want).
 

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

add two cells from seperate work sheets into a cell on seperate wo 6
How do I seperate a full name field out into three seperate columns? 3
Seperate cell string into individual cells 2
Copying first three characters of text in a cell 3
parsing a full name out into Last, First, Middle 2
Seperating of Text in one cell into two columns 1
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
setting cell values based on a 3rd cell 4

Top