I'd already tried that too. Doesn't work.

Thanks,

Ian

"Jim Thomlinson" wrote:

I have not tested it but you could try using the tilde character in front of
the apsotrophe. The tilde (~) allows you to look for special characters like
the astrix...
--
HTH...

Jim Thomlinson


"R. Ian Lee" wrote:

Yes. That's what I've been doing and Excel finds no matches. It will work
if I "Look In" values during a Find. But when doing a Replace, I only get
the option to "Look In" formulas. It can't seem to find the character in
formulas.

Thanks,

Ian

"John Lyons" wrote:

Have you tried dragging the mouse over the right-slant apostrophe, copying
it, then used find & replace and pasting the RH apostrophe in the find box?

John

www.magicspreadsheets.com

"R. Ian Lee" wrote:

Hello,

I have a worksheet that has some long text in a column of cells. Some of
the words contain right-slant apostrophes ( ) which cause problems with the
program that imports this data. Since there are many instances of this
character that I need to replace with a standard apostrophe ( ' ), I thought
I would do a find & replace to clean up the data. However, Excel will only
find this character if I tell it to find in the "values". The replace only
allows me to search on "formulas" and therefore doesn't find the characters
to be replaced...

Also, I have discovered that if I do get it to find some text it then
complains about the formula being too long...

Anyone know a solution to these problems?

Thanks!

Ian