Data literacy · Excel · Information literacy · Microsoft Office · Working with Data

#268 Excel wildcard search

In Excel we can find parts of things. So rather than looking for a chuck of text line “Jones” or “Johnson”, we can find both using wildcards. Wildcards are characters that tell Excel how to search. The asterisk (*) finds any number of characters, while the question mark (?) finds a single character. If you want to look for an asterisk or a question mark, put the tilde (~) character in front of either the asterisk or the question mark to search.


Featured image “Patterdale mountain rescue duck race” courtesy of Si Wilson released under CC BY-NC-SA 2.0

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s