Select Page

Now that we know how to find things in Excel, Excel Video 268 shows how to find parts of things. By parts of things I mean rather than looking for an entire CPT code like 99201, we can search for all of the codes that start with 992 or that end in 1. The trick is to use wildcards, 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. We’ll do an example of each search in today’s video.
Now that we have wildcards in our searching toolbox, we’ll look at how to add even more power to searches with the options menu. We’ll start that next time. Thanks for watching.