Excel: Getting numbers from cells Closed

Question

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!

Excelguru · Answer

Use FIND function to check the position of spaces(" ")
Use mid function to get the desired words between spaces

JW · Answer

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.

Excelguru · Answer

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

Excel: Getting numbers from cells

3 responses

Similar discussions

Subscribe To Our Newsletter!