Formula for extracting numbers only from a cell

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.
 
M

Mike H

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

Conditional Autofilter For Formula 4
Formula to find the last number of a column (lower cell) 1
selecting next available cell 5
how to extract numbers from imported cell with text and numbers? 3
Dynamically reference a cell based on cell content 1
Cell Update only at a specific time. 3
Formula 5
Formula for Multiple "IF's" or maybe "COUNTIF's"??? 7

Top