| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search function keeps quitting in Excel | Excel Worksheet Functions | |||
| Disable Search Function In Excel Worksheet | Excel Worksheet Functions | |||
| Excel search function | Excel Discussion (Misc queries) | |||
| Excel Search function | Excel Discussion (Misc queries) | |||
| Help with a complicated search function in Excel | Excel Worksheet Functions | |||
Linear Mode
