If funtion wildcard
 

Is it posible to create an if function based on a partial text strim?

=if(left(a1,3)="Joe",etc

--
Don Guillett
SalesAid Software

"unodemad" wrote in message
...
Is it posible to create an if function based on a partial text strim?

With the help of other functions

=IF(LEFT(A1,3)="abc","do","don't")

will look at the 3 first characters

=IF(ISNUMBER(SEARCH("abc",A1)),"do","don't")

will look for the string "abc"


=IF(COUNTIF(A1:A1,"*abc*")0,"do","don't")


will actually use wildcards, the above basically is the same as the search
formula



Regards,

Peo Sjoblom



"unodemad" wrote:

Is it posible to create an if function based on a partial text strim?