Can I filter cell that have only 0-9 number in it?

[lazyx]

Hi,

Can I filter cell that have only 0-9 number in it?

I mean that I have 1 column like below:

samsung
samsung galaxy s2
samsung galaxy
samsung galaxy tab
samsung galaxy nexus
samsung galaxy note
samsung infuse
samsung galaxy tab 10.1
samsung tv
samsung galaxy s3
samsung galaxy s

I want to filter cells that have any number in it (0-9). So, the en
result should shows only :

samsung galaxy s2
samsung galaxy tab 10.1
samsung galaxy s3


I'm newbie here. Please teach me.

Thank you

 

[Claus Busch]

Hi,

Am Fri, 13 Jul 2012 03:48:45 +0000 schrieb lazyx:

samsung
samsung galaxy s2
samsung galaxy
samsung galaxy tab
samsung galaxy nexus
samsung galaxy note
samsung infuse
samsung galaxy tab 10.1
samsung tv
samsung galaxy s3
samsung galaxy s

I want to filter cells that have any number in it (0-9). So, the end
result should shows only :

your products in column A from A2 on. Then make a helper column with the
formula:
=COUNT(FIND({1;2;3;4;5;6;7;8;9;0},A2))>0
and filter the helper column for TRUE


Regards
Claus Busch

 

[Claus Busch]

Hi,

Am Fri, 13 Jul 2012 10:03:17 +0200 schrieb Claus Busch:

your products in column A from A2 on. Then make a helper column with the
formula:
=COUNT(FIND({1;2;3;4;5;6;7;8;9;0},A2))>0

change the formula to:
=COUNT(FIND({1,2,3,4,5,6,7,8,9,0},A2))>0


Regards
Claus Busch

 

[lazyx]

That's work.

Thank you Claus Busch. You're the best :