Looking for the * in the Find function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 ~~)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alt codes 4
Example Spreadsheets 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Find & Replace in Excel 2007 3
="'"&F1&"'," Excel errors in one spreadsheet but not other one? 1
How do you find and replace unwanted symbols in text cells? 2
Find and Replace variable string 11
permenently set options of the 'find' comand to look 4 values 1

Back
Top