wild card characters
Posted by Andonny on December 22, 2000 2:03 AM
Hi,
I have this formula =if(A1="Date","5") . I have "Date 15/12/00" in A1 and I would like to have the answer of 5 if part of the cell matches. I think it is called a wild card. I tried a few things but it didn't work for me.
Kind help would be very much appreciated
Andonny
Posted by Tim Francis-Wright on December 22, 2000 7:43 AM
Try:-
=IF(ISERR(FIND("Date",A1)),0,5)
Gives 0 if Date is not a subset of A1, and 5
if it is.
Good luck!
