Excel Find/Replace

A description of Excel's find and replace functionalities.

Contents

Queries

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`

To use a literal question mark (?), asterisk (*), or tilde (~) in a query, escape using a single tilde (~). Hello~? matches Hello?.