| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Thanks Dave. The macros worked perfectly!
"David McRitchie" wrote: In addition you might take a look at SepTerm and SepLastTerm in http://www.mvps.org/dmcritchie/excel/join.htm it's a matter of what your data actually is and I think this would fit your situation. You will have to join names like de Bruin first though like de_Bruin and the remove the underscore later. Insert two new columns to the right of the name first use the SepTerm macro then use the SepLastTerm macro on the 2nd column. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Don Guillett" wrote... Chip has some extensive discussion. http://www.cpearson.com "maryj" wrote in message ... 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. |
| 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
