View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
craezer craezer is offline
external usenet poster
 
Posts: 5
Default 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.