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/
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/