Extract mixed of text numbers characters

[sotor]

I tried to extract mixed text & numbers using formula =MID(LEFT(A1,FIND("T",A1)+9),FIND("T",A1)+0,LEN(A1))
I also tried extending it for other mixed characters but not having much luck.

Anyone have a solution for the data below?

Detail	Result needed
F-001\017548942\T048321/EM/41/KC/TB/jn\	T048321EM
D-001\4535623-0001\D100492EM	D100492EM
D-041\012258188\D100035EM--17/REN\001361430-0017	D100035EM
F-005\002913831\KC/TB/B.208.0444\016300576\BT	B.208.0444
F-005\003049918\AMSF/RJP/F.043.0501\017604273\Fi	F.043.0501
F-012\006564975\AAR.24-5\AMER	AAR.24-5
F-005\003055137\KAE/SHF/K.024.0013\017872828\V	K.024.0013
F-005\003056146\M.167.0289\017825084\m	M.167.0289
F-116\000751537\MAL/CT25330\Tel	CT25330
F-020\014739422\O046865/EM/35/JML\	O046865EM

<tbody>
</tbody>

 

[sotor]

Don't know what your problem is, Works for me...

	A	B
12	F-001\017548942\T048321/EM/41/KC/TB/jn\	T048321EM
13	D-001\4535623-0001\D100492EM	D100492EM

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet349​

Strange? Did the same copy paste. Can you send the excel file?

 

[jtakw]

Please copy the formula from Above Post.


Had to try a few times before the formula will show correctly, it IS correct in Post # 10 Now.

 

[sotor]

Cool it works! No sure how express my gratitude. You are a genius! Thank you so much.

 

[jtakw]

Cool it works! No sure how express my gratitude. You are a genius! Thank you so much.

You're welcome, welcome to the forum. Clicking on "Thanks" and "Likes" would be nice..