FYI: Parsing (splitting) names and addresses (MSKb)

[Tana Lee]

Aloha...

I was just wandering around in the MS Knowledge base and found these articles on parsing names and addresses. Thought I'd post for others who are looking for similar info.

XL: How to Parse Data Using the Text To Columns Command
(142149) - This article contains information about how to parse data in Microsoft Excel by using the Text To Columns command.
http://support.microsoft.com/default.aspx?scid=kb;en-us;142149

HOWTO: Parse City, State, and Zip Code into Separate Values
(168798) - This article provides a procedure for parsing a single variable containing US City, State, and Zip Code information into three separate variables. The routine supports: Either 5- or 9-digit zip code. Multi-word state names (if preceded by a comma)....
http://support.microsoft.com/default.aspx?scid=kb;en-us;168798

HOWTO: Parse a Person's Name into Multiple Variables
(168799) - This article provides a procedure for parsing a single variable containing a person's name into up to 6 parts: Title (Mr., Ms., etc.) First Name Middle Initial(s) Last Name Pedigree (Jr., Sr., III, etc.) Degree(s) (B.S., PhD, etc.)
http://support.microsoft.com/default.aspx?scid=kb;en-us;168799

XL: Parsing Names in a Worksheet Without Data Parse in Excel
(72573) - You can parse data into separate cells by entering formulas into the first row of a worksheet and filling those formulas down. In those cases where using the Data Parse command isn't working properly, and you do not want to write a macro, this may be...
http://support.microsoft.com/default.aspx?scid=kb;en-us;72573

Tana-Lee