wild card with if logical function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

b166er - 01 Jun 2006 07:49 GMT

hi members,

i need help on how to use wild cards(*/?) with if logical
function is it possible to use with if logical function if yes please
just tell me how to use wild cards dont tell me about alternative
functions.

Signature

b166er

Reply to this Message

Nika Lampe - 01 Jun 2006 18:42 GMT

Hi,

there is possible to use wildcard characters, but you need to nest SEARCH or
FIND function into If.
Sample:
=IF(ISERROR(SEARCH("?ka",A1)),"no match","contains_ka_at_the_end")
will return "contains_nec..." when you search for words that end with "nec".
If search condition is in form "abc?" it will return match if word begins
with defined characters.
Of course you can also use * wildcard character.

Regards,
Nika Lampe

"b166er" je napisal:

> hi members,
>
> i need help on how to use wild cards(*/?) with if logical
> function is it possible to use with if logical function if yes please
> just tell me how to use wild cards dont tell me about alternative
> functions.

Reply to this Message