Grow your YouTube channel like a PRO with a free tool
Get Free YouTube Subscribers, Views and Likes

How to Use Wildcard Characters in Excel (Examples)

Follow
TrumpExcel

There are three wildcard characters in Excel:

1. * (asterisk) – It represents any number of characters. For example, ex* could mean excel, excels, example, expert, etc.

2. ? (question mark) – It represents one single character. For example, Tr?mp could mean Trump or Tramp.

3. ~ (tilde) – It is used to identify a wildcard character (~, , ?) in the text. For example, let’s say you want to find the exact phrase excel in a list.

In this tutorial, learn how to use Wildcard Characters in Excel.

Examples include:
Counting Nonblank Cells using Wildcard Characters.
Doing a Partial Lookup.
To Find and Replace Partial Matches.
To Filter using Wildcard Characters in Excel.

Read More: https://trumpexcel.com/excelwildcard...


Let's Connect:
Google+ ► https://plus.google.com/+Trumpexcel
Facebook ►   / trumpexcel  
Twitter ►   / trumpexcel  
Pinterest ►   / trumpexcel  


Free Excel Course https://trumpexcel.com/learnexcel/
Paid Online Training https://trumpexcel.com/exceltraining/
Best Excel Books: https://trumpexcel.com/bestexcelbooks/

⚙ Gear I Recommend:
Camera https://amzn.to/3bmHko7
Screen Recorder techsmith.z6rjha.net/26D9Q
USB Mic https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

posted by purasmujeresjs