Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Newbie question
Hello everyone,
I have data on a number of rows that looks like this (all in the same cell) Carton cheese 12x350oz Carton wine 8x500ml Carton cheddar 24x200oz What I want is to just extract the 12, 8 and 24 to appear alongside, in a separate column - I have tried text to colums but unsuccesfully, any thoughts? The text length before the number is uneven, I guess that' s where my problem is?? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
newbie question | Excel Worksheet Functions | |||
Newbie With A Question | Excel Worksheet Functions | |||
Newbie question: Matching data/2 wkshts copying info over | Excel Worksheet Functions | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) |