extract text connected by an underscore from a string of text

[JDL623]

Hi, Is there a way to extract a string of text connected by an underscore into a new column?

Thank you

[m_dekorte · Accepted solution]

Hi @JDL623 

Give this a go:

Text.Combine( List.Select( Text.Split([Description], " "), each Text.Contains(_, "_" )), ", ")

I hope this is helpful

[JDL623]

This worked perfectly. Thank you!