Substring words from String after Symbol

[Kavindya]

Hi all,

I'm having dought about to Substring the words from long sring. I need to know how to get the last word after this Symbol "_" . 

String as below,

ABC_QST_GHY_19_TEST  ----------------> result - TEST 

ABC_QST_GHY_20_TEST02 ----------------> result - TEST02 

I need to get the word after "_" symbol.

Thanks in advance fro your support. 

[Vijay_A_Verma · Accepted solution]

Use this where Data is name of column

= Text.AfterDelimiter([Data],"_",{0,1})