Locate and Extract

I have the following information in one column, I just need to extract the job name from the text. The Job name starts with "XX" but that can come anywhere in the string and no definite pattern is followed. so Need to find a string starting with XX and get the whole word into another column. How can I do it ?


ABCFGTTJJ job XXVA12MX VT12MX05 VT12MX -
Type 3 job XXVA73RA step VK73RXS5 AAAAMFB08 JCL PROBLEM
Type 2 job XXVA69RA step VK69AABB ABEND=S000 U4038 OPEN or CLOSE of file PORTFIL2



The Result should be like this

XXVA12MX
XXVA73RA
XXVA69RA

Any help on this one ?

Assuming the job number is always 8 characters, this will do it

=MID(A1,SEARCH("XX",A1),8) assumes A1 contains the text

Matt

Excellent, Mallycat.. Works great.. Job done in one minute which would have taken hours if done manually.