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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2