Extracting only part of a Text

[#1]

How can I get the just the underlined text from the following string i.e. "dfgdfgdfg" using a condition. This is data displayed in a Pivot Table under a Column.

["Enterdescription_migNSC:dfgdfgdfg"]