Find and Replace in Word 97

Use Ctrl+V to paste it into the Find What control of the Edit Replace dialog
(Put the cursor in that control first.

You are probably better to replace it with a tab ^t rather than a period as
I think that will be recognised as a "next cell" instruction by Excel. I
don't think that a period will be.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"Paul" wrote in message
...
I have a "notepad" file with data (name, address, city, state, zip) that I
am trying to import into Excel into respective columns but will not because
this Notepad "text" file only imports in to 1 column because the data is set
up as Name Address City State Zip WITH A VERTICAL BAR between each. So
someone tells me open the file in Word and do a find and replace to elimate
the VERTICAL BAR and replace with a period (.) than import to Excel where
each Name, Address etc will each be in a column.

However, when doing Find and Replace in Word can't figure out what this
vertical bar is and how to get it into the FIND so I can replace with a .
Every time a try copy and paste it won't paste it into the FIND window but
pastes it onto the Word Doc instead.

Hope this makes sense without you seeing the file.

Any questions I'm at and I can send you the file.

Thanks.

Thanks Doug!

Got it on the first try! Usually I don't have the patience to post a question here and wait but worth it - you guys are the best!

That problem was a pain.

Thanks again.
-Paul