Extracting text and numbers out of a string

[Peter Davison]

I have a string in a cell (see below)

PL-AF4-01B-M-Aflex

Firstly I want to extra just the AF4 and I used the following formula -
=RIGHT(LEFT(U2,6),3)
It works, but I just wanted to check if this Is this the correct way of doing it?

Secondly
Same string, I wanted to extract 01 and I used this formula -
=RIGHT(TEXTJOIN("",TRUE,IFERROR((MID(U2,ROW(INDIRECT("1:"&LEN(U2))),1)*1),"")),2)
I feel sure I may have gone a long winded way of doing it.
It does work, but is there a simpler formula?

Really appreciate your help.

 

[Rick Rothstein]

One example is not usually enough to go on, but if your strings are always composed at the beginning with 2 characters, a dash, 3 characters, a dash then the two digits you want, then try these those formulas...

=MID(U2,4,3)

=MID(U2,8,2)

 

[Peter Davison]

Wow, how simple to do.
I was ages trying to work it out.
I couldn't see anything like that on google but maybe my search wasn't very good.
Thank you so much for your time.