Autofilter cells containing wild card characters

[dcullen]

Hi

I am using an Excel 2000 spreadsheet in which I want to
use an auto filter to analyze the data on the sheet. The
sheet is populated from a database extract which I have no
control over.

Some all of the records on the sheet start with a leading
space (e.g. ' United Kingdom') which shouldn't cause any
problems when filtering. However, some of the records have
fields which start with a space then one on the Excel
wildcard characters (e.g. cell would contain ' *United
Kingdom'). When I try to filter on these records the rows
I am trying to select are not displayed.

Does anyone know if this behaviour is by design or of any
suitable workrounds? (can't do find-replace because the
characters are wildcards so everything gets replaced)

Many thanks in advance

 

[Debra Dalgleish]

Type a tilde ( ~ ) before the wildcard character, and it will be treated
as a regular character. For example: ~*United Kingdom

 

[ElsiePOA]

Use Edit - Replace. In the Find What box enter ~*. That will allow yo
to remove all of the asterisks