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: email@sbcglobal.net

*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: email@email.com

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: email@email.com

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         email@email.com

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.functions/browse
_thread/thread/979dda8d56df1bbb/f8f30df7966ed438?lnk=st&q=parsing+address+excel+
from+one+column&rnum=20&hl=en#f8f30df7966ed438
and
http://groups.google.com/group/microsoft.public.access.externaldata/browse_threa
d/thread/1bc452285fb816b0/374cd9a346a2130d?lnk=st&q=parsing+address+excel+from+o
ne+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/