On Fri, 13 Jul 2012 03:48:45 +0000, lazyx wrote:


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 end
result should shows only :

samsung galaxy s2
samsung galaxy tab 10.1
samsung galaxy s3


I'm newbie here. Please teach me.

Thank you.

You can use the Advanced Filter, to either Filter in Place, or copy the Filtered list to a new location

Insert a Label for your list above the list; and insert at least three blank rows above the list.

A1: <leave blank
A2: =MIN(FIND({1,2,3,4,5,6,7,8,9,0},A5&"1,2,3,4,5,6,7, 8,9,0"))<=LEN(A5)

(Note that the A2 cell reference is to the first actual item in your list, not the label)

A4: Item
A5:A15 Your list from above

Then select a cell in your list
Advanced Filter
Action: As desired
List Range: $A$4:$A$15
Criteria Range: $A$1:$A$2

Copy To: (only if you have selected to copy to another location)