Looking for the * in the Find function

D

Dick

I am trying to find and replace the * in my spreadsheet. For some reason excel will not find it for m
Any suggestion

Thank you in advance
 
D

Dave Peterson

try ~*

* is a wild card. so to tell edit|find you really want to to find the character
*, you have to give it a little more info.

Same thing with ? (use ~?)

And since ~ is used as this control character, you need it for that one, too.
~ (use ~~)
 
A

Antônio Gonçalves Junior (Brazil)

I have had a problem like that a couple of weeks ago, and the solution I found was to copy from Excel to Word the column which had the *and then I replaced it in Word and then copied it back to the spreadsheet. It worked fine

Hope it helps

----- Dick wrote: ----

I am trying to find and replace the * in my spreadsheet. For some reason excel will not find it for m
Any suggestion

Thank you in advance
 
Top