Assuming the values are in column A.

1) Click on B1
2) Enter the formula below
3) Grab the fill-handle of B1 (lower right corner), and drag down as far
as required
4) Select columns A:B
5) Choose Data/Autofilter
6) In the B1 dropdown, choose Custom Filter
7) Using the dropdown and combobox, choose "is less than or equal to" 2
8) Click OK


In article ,
Chops wrote:

Ok I will try this, so do I click on column B and then what do I do. Sorry I
am so new to this.

Thanx
Carolin

"JE McGimpsey" wrote:

No, but a modification of the third one will:

=COUNTA(A1)+LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))