Wildcards in formulas?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RD - 15 Mar 2006 18:52 GMT

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

Reply to this Message

Dave Peterson - 15 Mar 2006 19:04 GMT

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

> Is it possible to use wildcards in formulas?
>
[quoted text clipped - 4 lines]
> Thanks
> rd

Signature

Dave Peterson

Reply to this Message

RD - 15 Mar 2006 21:30 GMT

Thanks Dave,

Gotta love newsgroups!

rd

> =if(right(a1,4)="-051","something","something else")
>
[quoted text clipped - 10 lines]
>> Thanks
>> rd

Reply to this Message