Return only numbers directly after specific substring

RaydenUK

Board Regular
Joined
Mar 25, 2014
Messages
74
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.
 
With the ";" I have the backslash "\" as column divider and the semicolon ";" as the row divider.

For ex., for L1:N2:

{"L1"\"M1"\"N1";"L2"\"M2"\"N2"}

Really funny working with both sets of dividers :)
As I said earlier... "Well, that sounds like fun..."

I am pretty sure switching back and forth would drive me crazy... thank goodness all my computer programming only has only had to deal with a US regional setting (that made things nice and easy for me).
 
Upvote 0

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Forum statistics

Threads
1,223,244
Messages
6,170,976
Members
452,372
Latest member
Natalie18

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top