Hi. I have a string for example like this:
<tbody>
</tbody>
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:
<tbody> </tbody> 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:
<colgroup><col></colgroup><tbody> </tbody> |
<tbody>
</tbody>