I have text strings in the form
0' - Start of straight line, Road R-6 RD 0'
397' - Road R-5 RD 0', Start of straight line
9234' - Road R-29 RD 6247', End of road
6141' - Road R-1 RD 9233', Road R-29 RD 6239', End of road
739' - Road R-149 RD 0'
2534' - End of road, Road R-40 RD 2267'
0' - Start of straight line, Road R-1 RD 0', Road R-20 RD 0'
I need to extract the R- numbers and the RD values as shown in the attached file. Excel formula preferred but VBA is also acceptable.