Hi. I have a string for example like this:
|AT R05DD84100TL DAAIA84100OT01A1ZTM DGMFL00991|
I want to be able to list out only the 5 characters after "OT". So in the above example it would be 01A1Z.
I can do that in two different cells using:
=MID(A2,FIND("OT",A2)+2,LEN(A2)) which gives me:
And then using:
=LEFT(B2,5) which will give me the 01A1Z
Is there a way to combine those functions or use something different which will give me what I need in one formula?
The OT that I'm looking for isn't always in the same spot of a string. In can be for example: