Is it posible to create an if function based on a partial text strim?
Is it posible to create an if function based on a partial text strim?
=if(left(a1,3)="Joe",etc
--
Don Guillett
SalesAid Software
[email protected]
"unodemad" <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks