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 Non-blank Cells using Wildcard Characters.
– Doing a Partial Look-up.
– To Find and Replace Partial Matches.
– To Filter using Wildcard Characters in Excel.
Read More:
Let’s Connect:
Google+ ►
Facebook ►
Twitter ►
Pinterest ►
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
very well explained – thanks!
You're amazing
This is absolutely useful!
Vry much Tq Sir
It’s better if you increase the view size of your excel because it is very small for us if we view in mobile
Thank you
you are awesome sir
great tutorial
Explanation is fast and without using zoom option video is not clear
You have an amazing knowledge of excel sir. Thank you for sharing 🙂
Hi I need help , every day I have to type many due date and effective date in excel , while typing date am using slash for ex: mm/dd/yyyy can we make slash should default come in excel column…….I have to type only num slash shd automatically come….. please help
Thank you
Hi, I need a solution to find the second match, Im using the formula
=VLOOKUP("*"&$B8&"*",INDIRECT("'"& $C$4 &"'!"& "B3:D500"),3,FALSE)
How do I look-up one word in a sentence within one cell? It must also highlight the word.
For the Vlookup function, is there a way to go the opposite way (i.e, look up ABC ltd and get ABC?)
Great example! Now I know "*" can also mean 0 number of characters
Great Excel wildcard video (and post) Sumit !