Extract numbers from a string of alphanumeric text

To All Excel MVP's i need your help.
Can anyone help me with a formula to extract numbers (account number) from a string of text that contains alphanumeric. the account number starts with 249,250,251 and TLC. Length for the 249,250 and 251 is 9; And for the TLC is 11. Any help is greatly appreciated. Thank you

Example. Assuming data is located in A1.

SERVICE REF: RELATED REF: ID: INS BK:XXXXXXX SER ID:PCRM SND BK: ID: 5ERANUA00000VBHJK303 249968059 91361 ID:001235737204 : ID: TLC29676085 BVDFGR 20140703-00004704 VAL D D ORIG 250360150 GTHYKKK BNNNG 566840000078955* CORRECT BK 45366363 PCRM DIGGGI SERVICE 251253955 BKSSSDR 56289

Richard.
For the most part its only 1 account number per string, but sometimes we have 2 or more.
Should be okay to have the result in a single cell.
Thanks for your reply.

The leading 3 characters (249,250,251 and TCL) are always in the same position. and they do not appear in the others strings that are not account number.

Originally Posted by TheCman81

If you dont mind having them in the same cell you can use this

=IFERROR(MID(A1,FIND(" 249",A1)+1,9),"")&" "&IFERROR(MID(A1,FIND(" 250",A1)+1,9),"")&" "&IFERROR(MID(A1,FIND(" 251",A1)+1,9),"")&" "&IFERROR(MID(A1,FIND(" TLC",A1)+1,11),"")

I entered the formula in cell A2 to get the result but its only showing blank.

Originally Posted by Richard Buttrey

Hi,

Given post #6 then in B1 enter

Formula:

Please Login or Register  to view this content.

Copy to D1 & E1 changing 91 to 178 & 259 respectively
In C1

Formula:

Please Login or Register  to view this content.

Thank you.