| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
splitting text to multiple columns
I have a list of people's names in a cell. Some examples a
Mr. John Doe Mrs. Jane S. Smith Ms. Cynthia Jones I need to split their titles, first name with Middle initial and Last name into 3 seperate columns. Using a post on this site, I was able to extract the title, but am unsure how to pull the other information. Thanks for you help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple font styles (superscript and subscript, for example) | Charts and Charting in Excel | |||
| Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel | |||
| How do I rotate a text box | Charts and Charting in Excel | |||
| Text Cuts Off | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
