| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for extracting numbers only from a cell
Hello,
I am tryiing to edit prices on a massive spreadsheet and want to know how to just select numbers out of a cell. Eg: Cell has "Quantity: 66" and I only want 66 Cell has " Price: $234" and I only want 234 There must be a formula for doing this. Hope someone knows, as it's doing my head in. Many thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for extracting numbers only from a cell
Hi,
If the examples you have posted are typical of your real data then this whould work. It looks for to colon =TRIM(MID(A1,FIND(":",A1)+1,LEN(A1))) Mike "antsml" wrote: Hello, I am tryiing to edit prices on a massive spreadsheet and want to know how to just select numbers out of a cell. Eg: Cell has "Quantity: 66" and I only want 66 Cell has " Price: $234" and I only want 234 There must be a formula for doing this. Hope someone knows, as it's doing my head in. Many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help Extracting Numbers formula | Excel Discussion (Misc queries) | |||
| Formula for extracting text formated numbers within ( )'s as numbe | Excel Discussion (Misc queries) | |||
| EXTRACTING NUMBERS FROM A TEXT CELL | New Users to Excel | |||
| Extracting numbers from a cell with carriage returns | Excel Discussion (Misc queries) | |||
| Extracting numbers from a cell | Excel Discussion (Misc queries) | |||
Linear Mode
