i want to select in a column, all number that are compose in 3 digits?

In a helper column you can have a formula like this:

=IF(LEN(A1)=3,"Yes","No")

or like this if your numbers are proper numbers:

=IF(AND(A1=100,A1<1000),"Yes","No")

Copy the formula down the helper column, then apply autofilter to that
column, selecting Yes from the filter pull-down.

Hope this helps.

Pete

"asorina" wrote in message
...
i want to select in a column, all number that are compose in 3 digits?

"Pete_UK" wrote:

In a helper column you can have a formula like this:

=IF(LEN(A1)=3,"Yes","No")

or like this if your numbers are proper numbers:

=IF(AND(A1=100,A1<1000),"Yes","No")

Copy the formula down the helper column, then apply autofilter to that
column, selecting Yes from the filter pull-down.

Hope this helps.

Pete

"asorina" wrote in message
...
i want to select in a column, all number that are compose in 3 digits?


Thank's,
it's works!
Have a nice day!

Thanks for feeding back.

Pete

On Mar 12, 6:40*am, asorina wrote:
"Pete_UK" wrote:
In a helper column you can have a formula like this:

=IF(LEN(A1)=3,"Yes","No")

or like this if your numbers are proper numbers:

=IF(AND(A1=100,A1<1000),"Yes","No")

Copy the formula down the helper column, then apply autofilter to that
column, selecting Yes from the filter pull-down.

Hope this helps.

Pete

"asorina" wrote in message
...
i want to select in a column, all number that are compose in 3 digits?

Thank's,

it's works!
Have a nice day!- Hide quoted text -

- Show quoted text -