Search for a Text String

[dcliffo]

I would like to create an IF statement that searches through a cell to find a string (e.g. "Administration"). If it finds it within the cell, I would like it to return a percentage in a different cell location. Anyone know how I would do that? I probably need some wild card characters

=IF(D2="*Administration*",C2,0)

Thanks!!

 

[PA HS Teacher]

=If(ISNUMBER(FIND("Administration",D2)),C2,0)

 

[dcliffo]

Thanks so much, but why do you use ISNUMBER since I'm looking for a text string?

 

[Nimrod]

FIND("Administration",D2) will return a number IF the string is found, Then Isnumber tests for that number ... if no number then the string was not found. :wink:

 

[dcliffo]

Thanks. I always like to understand the formulas for next time. Appreciate the super fast response. Looks like you have no life other than work as well!!

 

[Nimrod]

Looks like you have no life other than work as well

I try to stay away from this site when I'm at work... it's to easy to have hours seem like minutes ... :wink: