Find the code inside the text and return the code in another column

Hello,

I have a list of data inside the cell and has a tag#. I need to separate that Tag# but it's a long list and sometimes the Tag is in the beginning and sometimes
it's in the end. It will be difficult to know which is a Tag number so i inserted in another sheet the list of Tag # that has to be separated and bring to another column.
I'm trying to separate the Tag from inside the cell because i want to use it in future for Vlookup reference.

I attached the file for easy reference.

Thanks again.

?? Is this what you wanted:

=TRIM(RIGHT(SUBSTITUTE(B2," ",REPT(" ",50)),50))

On second thoughts:

=IFERROR(LOOKUP(1000,SEARCH(Tag!$A$2:$A$86,B2),Tag!$A$2:$A$86),"")

if not, please read the yellow banner (top) about sample sheets and add a small sample WITH EXPECTED answers.

Thanks!

You're welcome.