|
Size: 714
Comment:
|
← Revision 4 as of 2025-04-08 16:52:14 ⇥
Size: 729
Comment: Cleanup
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| = Excel Search Queries = | = Excel Find/Replace = |
| Line 3: | Line 3: |
| [[Excel|Microsoft Excel]] uses a custom format for search queries. | A description of Excel's '''find''' and '''replace''' functionalities. |
| Line 11: | Line 11: |
| == Wildcards == | == Queries == === Wildcards === |
| Line 21: | Line 25: |
| === Escaping Literals === | === Escapes === |
Excel Find/Replace
A description of Excel's find and replace functionalities.
Contents
Queries
Wildcards
Excel supports the following wildcard patterns for queries.
Pattern |
Meaning |
Example |
? |
Any single character |
sm?th matches smith and smyth |
* |
Any number of any character |
*east matches Northeast and Southeast |
Escapes
To use a literal question mark (?), asterisk (*), or tilde (~) in a query, escape using a single tilde (~). Hello~? matches Hello?.