Types of Excel Wildcards

Rumman Ansari   Software Engineer   2025-01-18 09:14:05   350  Share
Subject Syllabus DetailsSubject Details Login to Open Video
☰ TContent
☰Fullscreen

Table of Content:

  1. Asterisk (*):

    • Matches zero or more characters.
    • Example: Ap* matches any text starting with "Ap."

  2. Question Mark (?):

    • Matches exactly one character.
    • Example: T?m matches "Tim" or "Tom," but not "Tammy."

  3. Tilde (~):

    • Escapes wildcards.
    • Example: File~* matches the literal text "File*," not "Files."
    • Example: "File~*" matches "File*" but not "File123" or "FileABC."


Stay Ahead of the Curve! Check out these trending topics and sharpen your skills.