Search for Word in String, bring back Word +

[patri0t82]

Hello, I'm trying to look in [Column] for the word "Scenario". If it finds it, I need to return "Scenario " + the next 2 characters. For example, the string may read "2040 3m Scenario 1 **DO NOT CHANGE**" and I need to return "Scenario 1"

[patri0t82 · Accepted solution]

Actually, I'll just look for Text.Contains "Scenario 1" or "Scenario 2" etc. That should do what I need, too. Sorry to bother!

[serpiva64 · Accepted solution]

Hi,

from this

to achieve this 

 you have to add a custom column

Text.Range([Column1], Text.PositionOf([Column1],"Scenario"),10)

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

[patri0t82]

That's perfect! Thanks so much for figuring this out for me!!

[patri0t82 · Accepted solution]

Actually, I'll just look for Text.Contains "Scenario 1" or "Scenario 2" etc. That should do what I need, too. Sorry to bother!