Return only numbers directly after specific substring

[RaydenUK]

I could really use some help with a formula... it needs to return the number directly following substring "RX" within a string? For example if i have the string "12354165RX15" then just show "15". Another example is "165163546RX15_G_B" then it would still need to also just show "15". I have tried a few different things with no luck.There shouldn't ever be anymore numbers in the string, other than the one immediately following the "RX". Also note that the number can range from 1-4 digits. Any help would be greatly appreciated.

[José Augusto]

Try this

Please Login or Register  to view this content.

Regards

[José Augusto]

Hi
Sorry, I don't see de range 1-4 digits.
The array formula is

Please Login or Register  to view this content.

Regards

[AlKey]

Try this one

in B1 and copy down

=--TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"RX","_"),"_",REPT(" ",99)),99,99))

Data Range

	A	B
1	12354165RX15	15
2	165163546RX15_G_B	15
3	165163546RX1525_G_B	1525

[LeoTaxi]

With a UDF

Please Login or Register  to view this content.

Kind regards
Leo

[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

Please Login or Register  to view this content.

Best regards

[AlKey]

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

Please Login or Register  to view this content.

Best regards

Why would it be not correct? The results are fine

Data Range

	A	B
1	12354165RX1595	1595
2	165163546RX15_G_B	15
3	165163546RX1235_G_B	1235
4	165163546RX1525_G_B	1525
5	165163546RX19	19

[José Augusto]

Hi Alkey


I apologize, I was testing your formula with a string that did not underscore to finish the number. Eg "165163546RX15G".

Regards.

[RaydenUK]

Thank you all greatly for the help!