Help me parsing Data and Organizing

D

dumb4ever

I search a lot of groups and only come up with a bunch of them.

I imported a text file that have customers name on it but customers
appear in the the same cell. So I have 5000+ cells on information all
in one column.
the data looks like this :
Last, First 111-222-333

Cellular..................111-222-333
Voice Mail..............111-222-333
Home....................111-222-333
Fax........................111-222-333
Contact................. 111-222-333

Century 21 Alliance
123 Cool Serra Blvd.
Los Angeles, CA 94015
E-mail: (e-mail address removed)

*Last, First 111-222-333
Home....................111-222-333
Fax........................111-222-333
Contact................. 111-222-333
Century 21 Alliance
111 39th Ave.
San Francisco, CA 94121
E-mail: (e-mail address removed)

Last, First 650-994-8800

Home....................111-222-333
Fax........................111-222-333
Contact................. 111-222-333

Century 21 Alliance
111 39th Ave.
San Francisco, CA 94121
E-mail: (e-mail address removed)

Is there a way to separate or parse all of this data into separate
field
that all
appear in one row? So I would want it to look like the following:

Column B Column C Column D Column E
Last First 111 29th Ave San Francisco CA

Column F Column G
94121 (e-mail address removed)

Thank You.

PS: I found 2 link that help me a little but not a lot
http://groups.google.com/group/microsoft.public.excel.worksheet.funct...
and
http://groups.google.com/group/microsoft.public.access.externaldata/b...

I also found a program that does that but i cant seem to figure it
out.http://beside.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top