Split numbers and text from 1 column into 2 columns
 

I have Size & Unit of Measure data in 1 column and need to split that to 2
columns (numeric size in the 1st and the UOM text in the second). I'm
looking for either formulas to use in each column or the code for 2 macros (1
to eliminate text and leave numbers only and the other to eliminate numbers
and keep text only). Text to columns doesn't work well since the data is not
consistent. Variations consist of (12.5oz, 12.5 fl oz, 0.14 oz/e, 12/4pk,
XXL-3XL, Mens, Carton, etc.)

I appreciate any ideas.

Thanks,
Kevin K