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

Hi @kahnailee 

Give this formula a try.

Workflow:

Hope this helps : )

sample_text_hello.yxmd