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/micr...rom+one+column&rnum=20&hl=en#f8f30df7966ed438
and
http://groups.google.com/group/micr...from+one+column&rnum=6&hl=en#374cd9a346a2130d

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

CLR

There's no quick and easy push-button solution. Because the conditions can
vary so widely from one download to another. About all you can do is to go
through manually identifying the similar repeated conditions and then record
macros to deal with them one at a time......and at the end, maybe even having
to change a few by hand...........not much help, but that's the way I do
it......

Vaya con Dios,
Chuck, CABGx3
 

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