Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 444
- Office Version
- 365
- Platform
- Windows
I have a string in a cell (see below)
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.
PL-AF4-01B-M-Aflex |
=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.