On Aug 10, 10:49 am, Thyag wrote:
On Aug 10, 10:22 am, "Rick Rothstein \(MVP - VB\)"

wrote:
Is there a way to use the search function to search non "0" value in
cell.

Ex - if i have "110254" in cell A1 - I need the position of non zero
digit in the string of A1.

Try this (note, there is no 0 in the list)...

=SEARCH({1,2,3,4,5,6,7,8.9},A1)

Rick

Thank you Rick.

But the formula checks only the existence of "1" and "2" to "9" is not
validated.