How can you find wildcards in Excel?? 1

[mymou]

Hi All

Need to find ******* in a worksheet.

How?

Stew "Even a stopped clock tells the right time twice a day."

 

[luceze]

Did you try putting quotes around the asterisks when searching? Just an idea.

 

[mymou]

Hi luceze

Tried that - no joy.

***** - finds everything

"****" - finds anything with two quotes

Any more ideas?

Word uses an option for wildcards - Excel doesn't have this option (not even in code as far as I can tell). Im out of (easy) ideas.


Stew "Even a stopped clock tells the right time twice a day."

 

[ETID]

try searching for char(42)

substitue your cell for A1

=SEARCH(CHAR(42),A1,1)

 

[Dreamboat]

Select all your cells.
Copy.
Paste into Word.
Do a find/replace there.
Click inside the table, hit Table-Select table.
Copy.
Select cell A1 in Excel.
Paste.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[mymou]

Hi Dreamboat

Had hoped for an easier way. This will be a minor pain in code (had been looking at some code for a word spell check in excel - and this was exactly how it worked. Copy, paste, check, copy, paste.)

Thanks all.


Stew

"Even a stopped clock tells the right time twice a day."