I have over a 100 lines like this....
Male Run Tee 10mm Tubexmale Bspt
They all are different numbers in front of the "mm".
Each string is a different length. I want to pull out the number in front and put into the next column. So in this case, the next column would show "10mm".
Thanks...