Advanced Filter Function Exclude

[Schlunggi]

I am trying to exclude lines which only contain " - " Space,dash (Char 32),space. I have tried just about any combination with <> (not equal) but excel is ignoring it.
If I use ="= - " it will filter only these lines, but I can not exclude them. Has anybody a solution?

 

[pmover]

not able to open attached file . . . please try attaching file again using "STEP 3" in posting procedure.

Thanks!
-pmover

 

[zelgar]

As pmover said, your file is inaccessible.

If your doing this with a macro, I'd do something like this:
1. Have a cell in your spreadsheet (e.g., A1)with " - "
2. In your macro make a variable refer to that cell (e.g., A$=Range("A1")
3. Have a condition when your data in a cell = A$

 

[Schlunggi]

I try a new upload and also will try the macro as suggested.
The problem is the <> not equal, the = equal works.
Thanks for the replies.

 

[zelgar]

Have you tried ="<> - "

 

[zelgar]

It seems like the ="<> - " gets rid of all, but one of the ones with just a dash. The one that it misses doesn't have the space after the dash.

 

[Clyde38]

Seems to work fine in Excel 2007. .

[link

http://www.linkedin.com/in/clydehancock

]

[/url]

 

[Schlunggi]

Great, this is the solution. Yes, the one which is not filtered needs a space after the dash as all others do.

Thanks for the tip.