What is the formula to start trimming from start of number?
Given:
*The numbers vary in length
*The numbers are all in the right side
Example
Product ABCD 13.5 oz
Product E .5 oz
Product FG 3 oz
I want to generate
13.5 oz
.5 oz
3 oz
Alternatively, extracting just the numbers could also work so instead of ".5 oz", I'd only have ".5"
Thanks!
Bookmarks