I am attempting to capture numbers that are embedded in a string of characters. The numbers are 4 characters long and they are also 5 characters long.
My example
BG9991A01ACR02012012 <- I only need 9991
&
BG99921P01ACR02012012 <- I only need 99992
I have attempted to use MID, (=MID(J72,3,5)), but in the first example I am also picking up the A which I do not need. Any suggestions?
Bookmarks