| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split 1 column to 3 columns | Excel Discussion (Misc queries) | |||
| How to split numbers and decimal in 2 columns | New Users to Excel | |||
| split range of numbers in two columns to as many as numbers in ran | Excel Discussion (Misc queries) | |||
| split column into 4 columns | Excel Discussion (Misc queries) | |||
| How do I split a column having numbers and text in a random order | Excel Worksheet Functions | |||
![Kevin K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
