Return only numbers directly after specific substring

**José Augusto** · 09-10-2015, 02:23 PM

Hi Alkey
I tested your formula and it seems to me that is not correct. Can you test again?
I test another array formula that is too short

Formula:

=MAX(IFERROR(MID(A1,FIND("RX",A1)+2,{4,3,2,1})*{1,1,1,1},0))

Best regards

**AlKey** · 09-10-2015, 02:29 PM

Originally Posted by José Augusto

Hi Alkey
I tested your formula and it seems to me that is not correct. Can you test again?
I test another array formula that is too short

Formula:

=MAX(IFERROR(MID(A1,FIND("RX",A1)+2,{4,3,2,1})*{1,1,1,1},0))

Best regards

Why would it be not correct? The results are fine

Data Range

Re: Return only numbers directly after specific substring