Coverting a series of Cells In a Column to Rows

M

mjmein

I have a list of organizations with Name, address, email etc. separated by
===================.
How do I convert these series of text in cells to rows? Here is an example
unfortunately, each group does not have the same amount of cells.


American College of Medical
Quality
4334 Montgomery Ave 2nd Fl
Bethesda MD 20814
301-913-9149 phone
301-913-9142 fax
[email protected]
http://www.acmq.org
[email protected]
Ms Bridget Brodie
Executive VP
==========================
American College of Medical
Toxicology
777 E Park Dr; PO Box 8820
Harrisburg PA 17105-8820
717-558-7846 phone
717-558-7841 fax
[email protected]
http://www.acmt.net
Executive Director
H. Miller
==========================
American College of Mohs Micrographic
Surgery & Cutaneous
Oncology
930 N Meacham
Schaumburg IL 60173
847-330-9830 phone
800-500-7224 phone
847-330-1135 fax
[email protected]
http://www.mohscollege.org
K. Hoarle
Executive Director
Ms Joanne Reichert
Meeting Planner
==========================

I have to convert about 500 organizations.

Please help if possible.
 
F

Frank Kabel

Hi
some questions:
- is there a maximum of rows per record
- what is the logic of these recors. Which items could be skipped
- how are the records separated (e.g. by a blank line, etc.)
- etc.
 
M

Mark

Hi,
I am assuming the text is in one cell and you want to
convert each line of data to a sepearate cell (row).

The only thing I can think of is to write the data to
a .tzxt file then import the file.

regards
mark
 
Top