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

  • Thread starter Thread starter EagleOne
  • Start date Start date
E

EagleOne

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
 
One way:

Custom Autofilter/Show rows where: xxx begins with ~*


(You can find this escape character in XL Help, "Wildcard characters you
can use to find text or numbers")
 
Works as expected. Thanks!

One way:

Custom Autofilter/Show rows where: xxx begins with ~*

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








- Show quoted text -
Click to expand...
 
Back
Top