Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

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
0
Rayne
Asked:
Rayne
2 Solutions
 
gnazarethCommented:
=if(left(F6,5)="Rainy","yes","no")
0
 
zorvek (Kevin Jones)ConsultantCommented:
In I6:

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

And copy down.

Kevin
0
 
RayneAuthor Commented:
Perfect Guys :)
thank you
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now