LifeTricks.com 
USER CP
Site Navigation 
UPVOTE
UP
41
DOWN
DOWNVOTE
 - Excel Spreadsheet Trick: Vague Search with Wild Card
UPVOTE
41
DOWNVOTE
  • life tricks short link

Excel Spreadsheet Trick: Vague Search with Wild Card


Question Mark stands for one character and Asterisk represents one or more characters. What if you need to search Question Mark and Asterisk as a target result? Don’t forget add a Wave Line in front.

Trick Source:

Is this trick using work of your own without attribution? Click here to PM the user and let them know!

Author Comments

Avatar of Love
amourdange says:

You may know how to activate the speedy search by using the shortcut Ctrl + F, but there are two main wild cards—Question Mark and Asterisk—used in Excel spreadsheets to activate a vague search. This is used when you are not sure about the target result.



User Comments