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.

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.