Excel: Getting numbers from cells [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hi everyone,

I'm looking for some Excel function help. I have some cells that have both numbers and text in them. I'd like to take the first few numbers out of the cell. They're merchandise descriptions - for example, a cell would say "12 orders of 3 lb packages". I'd like to have Excel create a new cell with just "12" -- not the text, and not the "3". Is this possible? And if so, how would I do it?

Thanks!

3 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Use FIND function to check the position of spaces(" ")
Use mid function to get the desired words between spaces
Thanks a lot for your reply. I don't think those formulas do quite what I want. First, I want to be able to search for numbers in general--not necessarily a specific number. Second, those formulas only allow me to specify where in the cell I want to start searching. I'd like to tell them where to STOP searching as well. In my example above, I'd just want to read 12, but not the 3. So I'd need to tell it to only read the first two characters.
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
What I meant is search spaces from 1 then from the location (already found+1) and so on . Then you will get the size of the number and from where to start

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!