Wildcards in formulas?

R

RD

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
 
D

Dave Peterson

=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.
 
R

RD

Thanks Dave,

Gotta love newsgroups!

rd

Dave Peterson said:
=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.
Click to expand...
 
Top