software

Is it possible to use wildcards in formulas?

I want to look at a cell and if it has the characters quot;-051quot; 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)=quot;-051quot;,quot;somethingquot;,quot;something elsequot;)

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

RD wrote:
gt;
gt; Is it possible to use wildcards in formulas?
gt;
gt; I want to look at a cell and if it has the characters quot;-051quot; then I would
gt; have the formula carry on to do something. the characters in the cell are
gt; either ???????-051or #######-### the last three numbers being 00#
gt;
gt; Thanks
gt; rd

--

Dave Peterson

Thanks Dave,

Gotta love newsgroups!

rd

quot;Dave Petersonquot; gt; wrote in message
...
gt; =if(right(a1,4)=quot;-051quot;,quot;somethingquot;,quot;something elsequot;)
gt;
gt; This assumes that the hyphen is really in the cell--not just a number
gt; format
gt; that displays it.
gt;
gt; RD wrote:
gt;gt;
gt;gt; Is it possible to use wildcards in formulas?
gt;gt;
gt;gt; I want to look at a cell and if it has the characters quot;-051quot; then I would
gt;gt; have the formula carry on to do something. the characters in the cell are
gt;gt; either ???????-051or #######-### the last three numbers being 00#
gt;gt;
gt;gt; Thanks
gt;gt; rd
gt;
gt; --
gt;
gt; Dave Peterson