If statem to search for special charecter 3

[Starlitnight]

Hi,
I would like to know how to create a formula that would search for an asterisk *.
If I write:
=IF(ISNUMBER(SEARCH(""*"",A1)),"<myfield>","")
Excel treats the * as a special charecter
is there any way around this?
Thanks

 

[bluedragon2]

=IF(ISNUMBER(SEARCH(""~*"",A1)),"<myfield>","")

add the ~ in front.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

Only need one set of quotes though:

=IF(ISNUMBER(SEARCH("~*",A1)),"<myfield>","")

If you use the function builder, it explains at the bottom. It also works for ?'s

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Starlitnight]

YES! That worked!
Thank YOU!

 

[GlennUK]

You also use the tilde ( ~ ) when using the Find/Replace command with characters that you don't want to be taken as wildcards.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.