excel search function

[Thyag]

Hi All,

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.


Thanks,
Thyag.

 

[Dave Peterson]

You have an active thread at your other post.

Hi All,

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.

Thanks,
Thyag.