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

Excel Spreadsheet Trick: Vague Search with Wild Card

Excel Spreadsheet

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