I've got a worksheet that contains cells with single-digit numbers but some of the numbers are preceded by a caret character (e.g. ^3).
There are hundreds of these.
I know I can use a helper column and formula to pull them out...
But why doesn't Find & Replace work with ^?
I've tried ~^ and ALT 94 but they don't work either.
What am I missing?
Bookmarks