Formula for extracting numbers only from a cell

  • Thread starter Thread starter antsml
  • Start date Start date
A

antsml

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.
 
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
 
Back
Top