Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 13th 06, 04:39 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 1
Default Help me parsing Data and Organizing

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:

*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:

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:

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

Thank You.

PS: I found 2 link that help me a little but not a lot
http://groups.google.com/group/micro...orksheet.funct...
and
http://groups.google.com/group/micro...externaldata/b...

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table and organizing data rixmix Charts and Charting in Excel 1 October 19th 06 05:16 AM
Help organizing data using Pivot Table Branden Excel Discussion (Misc queries) 0 March 21st 06 07:53 PM
Problem organizing text data into new excel page Tony Excel Worksheet Functions 3 October 21st 05 08:19 PM
Help with organizing data Eaglered Excel Discussion (Misc queries) 2 May 18th 05 07:11 PM
Organizing Data trini Excel Worksheet Functions 5 April 21st 05 04:47 PM


All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017