that is another good idea...would have never thought of that one. Thanks!!

"wjohnson" wrote in
message ...

From Your Example if each of the following items is on its own line like
your example:
Joe's Bar and Grill
1000 Somewhere Dr
City ST Zip
Contact: Joe Schmoe
Phone: 800-000-000
Fax: 800-000-000
County: WhoKnows
Make sure there is a paragraph return after each line. Your might have
to turn-on "SHOW/HIDE" paragraph marks (look for the paragraph symbol
on your menu bar. You will also need to remove "Manual Line Breaks" and
any "Tabs" that are present. Tab looks like a -, and manual line break
will be a different symbol than a paragraph mark at the end of each
line. These are found in the Find and Replace popup menu - then select
"MORE" - then "SPECIAL"
Once the "tabs" and "manual line breaks" are removed:
Then do a SELECT ALL
Then on the MENU BAR - Select Table - Convert - Text to Table.
Then in the "Number of Columns" enter 7
Then in the "Columns Seperated By" Check "Paragraph Marks" and then
Click OK.
Now everthing should go into X number of rows and 7 Columns.
Then select one column at a time and in the FIND and REPLACE box -
enter what you want to delete and then say ok.
You will get a message that says "Items in Selection have been replaced
- Do you want to continue" select the NO Button.
Once you have your stuff cleaned-up - Copy the table and paste it into
EXCEL. In Excel you might select 7 Cells and Select text as the format
- and then paste special - paste as text. Then reformat your cells as
necessary.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile:
http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=498040