sub string Formula Excel

Hello
Looking for excel formula that does this. There is a target substring “Rainy” that always starts at the first part of the main strings in column F. If the formula finds that target substring, it marks it as “yes” for column G.

thanks
formulaQuestion.xlsx
RayneAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
In I6:

=IF(ISERROR(FIND("Rainy",F6)),"","Yes")

And copy down.

Kevin
0
 
gnazarethConnect With a Mentor Commented:
=if(left(F6,5)="Rainy","yes","no")
0
 
RayneAuthor Commented:
Perfect Guys :)
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.