Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spilt Entire Name into Two columns
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spilt Entire Name into Two columns
DataText To Columns
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jeff Farrar" . (donotspam) wrote in message ... -- Jeff Farrar .(donotspam) MCSE, NT 4.0, W2K |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spilt Entire Name into Two columns
Sorry...I inadvertently hit the "Enter" key and submitted a blank post.
My mailing list spreadsheet of 1200 names has column A with the entire name in the format of Doe, John. Our CEO wants a personalized letter sent to everyone on the list which reads, Dear First Name. I am able to split this column into 2 columns and accomplish this BUT I have quite a few columns where I am having problems. Some of the problem names a Smith, James F. {The middle initial is the problem-its placed into a separate column} Jones, Dr. Mike G. {the Dr. is the problem-resulting split is Dr. Mike-should read Dr. Jones.} There are really not enough of these errors for it to be a large issue and consume the boards time and resources. If there is a simple solution, though, Id be interested in any ideas as I can correct the errors manually. Thank you, Jeff Farrar -- Jeff Farrar .(donotspam) MCSE, NT 4.0, W2K "Jeff Farrar" wrote: -- Jeff Farrar .(donotspam) MCSE, NT 4.0, W2K |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spilt Entire Name into Two columns
Jeff,
Parsing names is a very complicated task if you want to accurately parse a variety of name styles. For example, St Clair Dr John James Jr MD Writing code to accurately parse out the first name, middle name (if any), last name, honorific, and suffix can get extremely complicated. I have some code at http://www.cpearson.com/excel/firstlast.htm that might help you get started, but it is a difficult nut to crack. Unfortunately, there is no simple way to do it. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Jeff Farrar" . (donotspam) wrote in message ... Sorry...I inadvertently hit the "Enter" key and submitted a blank post. My mailing list spreadsheet of 1200 names has column A with the entire name in the format of Doe, John. Our CEO wants a personalized letter sent to everyone on the list which reads, Dear First Name. I am able to split this column into 2 columns and accomplish this BUT I have quite a few columns where I am having problems. Some of the problem names a Smith, James F. {The middle initial is the problem-its placed into a separate column} Jones, Dr. Mike G. {the Dr. is the problem-resulting split is Dr. Mike-should read Dr. Jones.} There are really not enough of these errors for it to be a large issue and consume the boards time and resources. If there is a simple solution, though, Id be interested in any ideas as I can correct the errors manually. Thank you, Jeff Farrar -- Jeff Farrar .(donotspam) MCSE, NT 4.0, W2K "Jeff Farrar" wrote: -- Jeff Farrar .(donotspam) MCSE, NT 4.0, W2K |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter entire columns | Excel Discussion (Misc queries) | |||
Concatenating entire columns | Excel Discussion (Misc queries) | |||
Concatenating entire columns | Excel Worksheet Functions | |||
Spilt value and currency | Excel Discussion (Misc queries) | |||
sharing entire columns | Excel Worksheet Functions |