How to AutoFilter certain cells in a column (in Excel not VBA) for an Asterisk "*" ?
 

2003/2007

Yep! There is always one in the crowd ....

Certain cells in a field (column) begin with "*"

How do I filter those fields when "*" is a wildcard.

I could handle this in VBA, but is there a way in Excel w/o helper
columns?

TIA EagleOne

How to AutoFilter certain cells in a column (in Excel not VBA) for an Asterisk "*" ?
 

One way:

Custom Autofilter/Show rows whe xxx begins with ~*


(You can find this escape character in XL Help, "Wildcard characters you
can use to find text or numbers")

In article .com,
EagleOne wrote:

2003/2007

Yep! There is always one in the crowd ....

Certain cells in a field (column) begin with "*"

How do I filter those fields when "*" is a wildcard.

I could handle this in VBA, but is there a way in Excel w/o helper
columns?

TIA EagleOne

How to AutoFilter certain cells in a column (in Excel not VBA) for an Asterisk "*" ?
 

Works as expected. Thanks!

On Aug 3, 9:40 am, JE McGimpsey wrote:
One way:

Custom Autofilter/Show rows whe xxx begins with ~*

(You can find this escape character in XL Help, "Wildcard characters you
can use to find text or numbers")

In article .com,



EagleOne wrote:
2003/2007

Yep! There is always one in the crowd ....

Certain cells in a field (column) begin with "*"

How do I filter those fields when "*" is a wildcard.

I could handle this in VBA, but is there a way in Excel w/o helper
columns?

TIA EagleOne- Hide quoted text -

- Show quoted text -