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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Extracting numbers from a text 2
Master in Excel help me with a formula 3
Want to make formula automatically figure out cell number in the r 1
Formula to extract number values only 8
Conditional Autofilter For Formula 4
how to extract numbers from imported cell with text and numbers? 3
How do I attach a number to a cell with text to use in a formula? 1

Back
Top