unable to search and replace quote marks (") in excel

Unable to find quotes in excell using the
find or replace feature, am able to find phrases that contain quotes but
not the quotes themselves.
ie:
if the data were: "test quotes"

excel would find [ "test ] and [ quotes" ] but not a single
[ " ]

any ideas?

on a dell latitude d620, Win XP, office 2003

thanks

Did you try replacing the [ " ] anyway? I did it on my Excel, it found ( "test text" ) but I replaced the [ " ] in "test text" which it found to [ . ] and it only replaced the [ " ' to [ . ] keeping Test text intact with to dots on either sides of them. Excel just finds the exclamation marks and the text between them, but when replaced, only the exclamation marks get replaced. Hope that this helped you.

it doesnt find any [ " ] to replace, it says that searching was finished and there are clearly many [ " ] in the spreadsheet.

The answer to this challenge, from nearly 4 years ago, is CHAR(34)

You can use this nested in a function like so:
=SUBSTITUTE("test quotes",CHAR(34),"%",1)

Which would return %test quotes"

=SUBSTITUTE("test quotes",CHAR(34),"%")
Would return %test quotes%

This post still has a fairly high search ranking. Hope that this helps someone along!

nice solution. Thanks for the update.