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?
<tbody>
</tbody>
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>