Extract ANY/ALL text from string that includes underscore

[kahnailee]

Sample string: This is sample_text_hello and goodbye

Desired output: sample_text_hello

I've tried RegEx but that seems to work for text AFTER the underscore. I can't use text-to-columns as I need the text before the underscore, of which is variable in length.

Suggestions?

[atcodedog05 · Accepted solution]

Hi @kahnailee 

Give this formula a try.

Workflow:

Hope this helps : )

[kahnailee]

@atcodedog05 , this is perfect, thank you!

[atcodedog05]

Happy to help : ) @kahnailee 

Cheers and have a nice day!