Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting column with text & numbers
I am trying to split a column in a product catalog containing text and
numbers so I can further process the numbers. Each cell is consistent in that the text is on the left side and numbers on the right. The problem is that the quantity of words and numbers may vary from cell to cell. The closest I've come is using space as a divider in "Text to Columns", but this results in more work and concatenating because of the variable cell size. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
How to insert text in one column and populate numbers in another | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
How do I split a column having numbers and text in a random order | Excel Worksheet Functions |