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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s