LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default How do I find & replace quote marks with the word inch?

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing a word document into an excel spreadsheet aganchingco Excel Discussion (Misc queries) 7 October 26th 06 11:39 PM
How do I find and replace the " mawmawball Excel Discussion (Misc queries) 8 December 22nd 05 01:19 AM
Find and Replace blakrapter Excel Worksheet Functions 3 December 15th 05 12:25 AM
find and replace steve Excel Discussion (Misc queries) 1 June 23rd 05 01:43 AM
Find and REPLACE within a selection, or column- not entire sheet/. smithers2002 Excel Worksheet Functions 4 April 21st 05 04:45 PM


All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"