Find num via refer array!

[stewart08]

dear excelers, one for the night:

how can one make refer to a number by a number array i.e.

0123456789 < nums array
1903724103 < what's above num "9"!

I need to find which number is above "9" should result in "1".

any last takers for the function

[davesexcel]

Hi,
Do you mean something like this??
0123456789 this = 0
1903724103 this = 8

If so then this could work

=LEN(A1)-FIND(9,A1)

[stewart08]

davesexcel its close, but each number is within a cell can I should use the LEN function here!
any ideas...

[davesexcel]

davesexcel its close, but each number is within a cell can I should use the LEN function here!
any ideas...

????
You want to change a value in a cell that is greater then 9 to 1, is this correct??
I could not see that from your original question, but is this what you want?

This code will loop through Column A and change a numbers over 9 to 1

Please Login or Register  to view this content.