Find and Replace in Word 97

[Guest]

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 (e-mail address removed) and I can send you the file

Thanks.

 

[Doug Robbins - Word MVP]

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

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.

 

[Guest]

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