logo-wlogologo-wlogo-w
  • Home
  • Classes
  • Training
  • Consulting
  • Blog
  • Contact
✕
5 Things to avoid in MS Excel
November 19, 2019
November 2019 update
December 13, 2019

Wildcards

November 28, 2019

⦁ Introduction

Wildcards are used as placeholders in excel. They are special characters that can take on any value they want to.

There are 3 wildcard characters in excel:

⦁ Asterisk (*) – Represents any number of characters

⦁ Question Mark (?) – Represents a single character

⦁Tilde (~) – Represents the literal meaning of any character (“?” Or “*” preceded by a “~” will not work as a wildcard but it will represent “?” or “*” itself)

Wildcard Usage Example:

WildcardRepresentsInputOutput Example
?One characterd?gdog / dig / dug
??Two charactersj??kjack / jock / junk
???Three charactersa???tadopt / alert / audit
*Any Number of characters*excel / microsoft / powerpoint
* - at the startEnds with "end"*endfriend / dividend / amend
* - at the endStarts with "st"st*start / statistics / string
* - in betweenContains "has" somewhere*has*emphasize / aghast / She has a ball
~ with ?Ends with "?"*~?Do you have a ball? / Anybody Listening?
~ with *Ends with "*"*~*Important*

Wildcards has its use in the following functions:

⦁ Filtering Data

⦁ Find and Replace

⦁ COUNTIF and SUMIF

⦁ VLookup

Contributor: Raj Rajeshwar Sharma

Third year B.Com (Hons) student at St. Xavier's College, Kolkata. I am pursuing CFA. I have been working at Leveraged Growth as a Finance intern for the past 3 months. I am a Finance enthusiast with keen interest in learning different programming languages.
Contributor Image Raj
Share
2

Related posts

December 16, 2021

Stacking in EXCEL


Read more
December 9, 2021

SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW


Read more
November 25, 2021

Circular Referencing Solution


Read more

Comments are closed.

✕

Categories

  • Google
  • MS Excel
  • MS Word
  • Power BI
  • Uncategorized
  • Stacking in EXCEL
    December 16, 2021
  • SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW
    December 9, 2021
  • Tips and Tricks of MS PowerPoint
    December 3, 2021
  • Circular Referencing Solution
    November 25, 2021
  • Printing tricks
    November 18, 2021
    Disclaimer Policy | Terms of Service
    Powered by Aswini Aswini Bajaj
    Website Designed & Developed by 'A PIXEL HOUSE'