I have a column (named size) that has contains both numeric and unit of
measure. I have extracted the numbers into a field but how can i extract the
unit of measure into another column? Example
ColA Col B Col C
12z = 12 z
12pk= 12 pk
1ct = 1 ct

Thank you!