Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Escape ? and * in Excel AutoFilter (Read 22883 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Escape ? and * in Excel AutoFilter
08.12.06 at 14:21:47
 
Escape ? and * in Excel AutoFilter
 
AutoFilter in Excel can be used to filter out only those rows that meet the criteria you set. You can search for data within the cells and show only those rows that match.
 
When you search for strings that contain a * or ? you may be caught by the fact that these have special meaning. A * is a wildcard and a ? is a placeholder. If you want to match a * or ? character in the string you need to escape them with a tilde (~).
 
Searching for cells with a /* you need to put in the criterium /~*
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1