Listing out 5 characters after certain string?

[JV63]

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: 01A1ZTM DGMFL00991 <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: AT R05DD84100TL DAAIA84100OT01A1ZTM DGMFL00991 ATA02A1DD05100TL AAATM ACAOT03A2CIA05100 ATA02A2DD05300TL DCATM DGBNB OT03A2MNC FF IA05300 Thanks <colgroup><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[steve the fish]

You virtually had it. Instead of using LEN(A2) use 5.

=MID(A2,FIND("OT",A2)+2,5)

 

[Norie]

Try this.

=MID(A2, FIND("OT",A2)+2,5)

 

[Joe4]

There are simpler options (as shown above), but you have already pretty much done all the work!
Just subsititute your first formula into your second, i.e.
=LEFT(MID(A2,FIND("OT",A2)+2,LEN(A2)),5)

 

[AlanY]

try

=MID(A2,FIND("OT",A2)+2,5)

 

[JV63]

Thanks everyone for the quick replies. I was close

=MID(A2,FIND("OT",A2)+2,5) worked perfectly.