View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default How do I find & replace quote marks with the word inch?

Highlight your range
Go to Edit Replace Find What: "inch" Replace with: inch

"Lele" wrote:

My data is filled with quote marks as an abbreviation for the inch
measurement. This creates a problem when I import my data to Quickbooks
which gets confused by the " character and still interpretes it as an end of
text character. In the past this really messed up the import, today
Quickbooks just drops the " from the import. How to I search and replace all
"s with the word inch so I can retain the inch specification in my data. I
have tried surrounding the " character with "s and this does not seem to work.

Thanks
--
Lele