separating address elements in one cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: T Hamann (anonymous_at_discussions.microsoft.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 06:07:25 -0800

Peggy,
There are a handlful of data tools available for parsing
both the Name elements and address elements even if they
do not have a consistent delimiter. recommendations 1) Do
a web search for parsing software (PeolpeSmith or other)
2) Contact a local mail house (these people deal with all
sorts of formatting issues and could either fix it for you
or offer recommendations. 3) If you want to outsourse it I
would glad to give you a quote.

Hope this helps.
Todd Hamann
585-259-0061
Rochester NY
>-----Original Message-----
>I have a large list of names and addresses I need to
separate into
>columns. Each cell includes one name & address, including
first (maybe
>a middle name) last name, address, city, state and zip.
The data is
>separated by commas but isn't always consistent. I am
trying to figure
>out a way to split the data into it's own columns (i.e.,
first name,
>last name, address 1, address2, address3, city, state,
zip).
>
>Here is some sample data so you can see some of the
issues I am dealing
>with (sometimes there is more than one address line or a
first middle
>and last name, for example). Any suggestions are so
appreciated.
>thanks!
>
>mike shoafstall, Colgate University, Po Box M4026, 13 Oak
Dr, Hamilton,
>NY 13346-1338
>Mary Van Stedt, 2200 S Beaumont Ave, Kansasville, WI
53139-9725
>Jennifer Harme, 2904 E 21St St, Sioux Falls, SD 57103-3308
>Karen L Jordan, 71 Dreamland Park Dr Apt 4, Fleetwood, PA
19522
>Kristen Rossi, Medical Center Dev., Alumni Relations,
3535 Market St
>Ste 750, Philadelphia, PA 19104-3309
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>