Is it possible to use wildcards in formulas?

I want to look at a cell and if it has the characters "-051" then I would
have the formula carry on to do something. the characters in the cell are
either ???????-051or #######-### the last three numbers being 00#

Thanks
rd

=if(right(a1,4)="-051","something","something else")

This assumes that the hyphen is really in the cell--not just a number format
that displays it.

RD wrote:

Is it possible to use wildcards in formulas?

I want to look at a cell and if it has the characters "-051" then I would
have the formula carry on to do something. the characters in the cell are
either ???????-051or #######-### the last three numbers being 00#

Thanks
rd

--

Dave Peterson

Thanks Dave,

Gotta love newsgroups!

rd

"Dave Peterson" wrote in message
...
=if(right(a1,4)="-051","something","something else")

This assumes that the hyphen is really in the cell--not just a number
format
that displays it.

RD wrote:

Is it possible to use wildcards in formulas?

I want to look at a cell and if it has the characters "-051" then I would
have the formula carry on to do something. the characters in the cell are
either ???????-051or #######-### the last three numbers being 00#

Thanks
rd

--

Dave Peterson