Split numbers and text from 1 column into 2 columns

K

Kevin K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split cells next to 1 cell 1
How can the font and size of (all) citation numbers be altered? 1
Extract Text in braquet and list of terms from 2 Docs 3
split text and numbers into separate cells 5
Splitting text into two columns 2
Split numbers and text 2
split one column into multiple columns 2
Splitting Numbers into Columns. 3

Top