View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Excel search function

But you have 5 non-zero digits in your example - which one would you
like to find?

Pete

On Aug 10, 4:02 pm, Thyag wrote:
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.