I used ~"" replaced by " in my test using Ctrl-H and it seemed to work okay.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mawmawball" wrote in message
...
Hello,
I've got approximately 3500 products in my spreadsheet. I'm not sure why,
but the apostrophe signs are multiply. For example """"""Product a is
2""x3"" long."""""

I've tried using find and replace with the ~" but I keep getting a
"Formula
too long" error message. I get the message if I try to find and replace
them
singularly and when I use the replace all feature.

Does anyone know how I can remove these apostrophes from my spreadsheet?
I've searched high and low and can't even find a reference to the error
message anywhere.