If string contains substring then

[joshman108]

I want to know if string "thislp" contains substring "lp".

I know I can use

if(isnumber(search("*lp*",a1)),"true","false")

but is there another way to do this? I just mean I'm wondering if there is a specific formula for such a task other than using wildcards. Thanks!!

 

[T. Valko]

You normally don't need the wildcards with the SEARCH function:

=ISNUMBER(SEARCH("lp",A1))

 

[joshman108]

huh, i swear on everything it wasn't working... weird. Thanks!

 

[T. Valko]

You're welcome!