Cut Before / Cut After

[bakaidora]

Dear Community,

I have an Excel sheet where I have a column with the Notes. This is a bulk text and I need to cut the NT user information out of this text.

I cannot say from which characters I need this information because it is different, the only thing I can say that the needed information is between two phrases.

e.g. "Q: NT-ID of affected user? A:ABC2BP Q: Client-ID / Computer name of affected user?"

And from this I only need ABC2BP. The phrases before and after ABC2BP are not needed for me, I would like to cut them.

Is there any easy solution which I can use to cut a words before and after the needed data?

Thanks in advance!

[Felipe_Ribeir0 · Accepted solution]

Hi @bakaidora 

Try this regex expression:

NT-ID of affected user\? A\:(.*?)\s

[Sarreddy]

@bakaidora