=find(numbervalue,a1)

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi All,

Is there a way where I can use the find function or
another similar to determine whether a cell containing a
string of text contains a number so i.e Astra 1.4 DTI it
would identify that there contains a number value in that
cell and would return the 7.

Ideally I want to extract the numbers so in this case
1.4. Notice that the number values change and the text
may be setout different with the number values at various
parts in the range of cells. All the cells I want to get
this information from are in Column A.
 
To get the position

=MATCH(TRUE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0)

entered with ctrl + shift & enter
 

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

search text string for number 10
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Custom Number Format for text 8
How to determine the combination of stamps? 3
Excel Need Countifs Formula Help 0
How to determine the value within specific cell position? 5
Use Formula to Replace A Cell 3
search text string within array 7

Back
Top