Excel search function
 

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.

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.

Excel search function
 

On Aug 10, 11:09 am, Pete_UK wrote:
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.- Hide quoted text -

- Show quoted text -

The first non "0" digit in th string.

Excel search function
 

With the value in A1

=MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9},A1&"1,2,3,4,5 ,6,7,8,9")),1)

will return the first non zero digit



--
Regards,

Peo Sjoblom



"Thyag" wrote in message
oups.com...
On Aug 10, 11:09 am, Pete_UK wrote:
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.- Hide quoted text -

- Show quoted text -

The first non "0" digit in th string.

Excel search function
 

On Aug 10, 12:18 pm, "Peo Sjoblom" wrote:
With the value in A1

=MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9},A1&"1,2,3,4,5 ,6,7,8,9")),1)

will return the first non zero digit

--
Regards,

Peo Sjoblom

"Thyag" wrote in message

oups.com...



On Aug 10, 11:09 am, Pete_UK wrote:
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.- Hide quoted text -

- Show quoted text -

The first non "0" digit in th string.- Hide quoted text -

- Show quoted text -

Thank you it is working fine.