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?

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

 

[sotor]

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

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

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]12[/TD]

[TD="align: center"]13[/TD]

</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..