Excel Wildcard Characters | Tutorial + Examples

preview_player
Показать описание

This video is a full tutorial of Wildcard Characters in Excel. I cover the asterisk (*), question mark (?), and tilde (~) -- what they mean and how to use them with practical examples.

Intro: 0:00
Overview: 0:32
Asterisk: 0:57
Asterisk with text joining: 2:03
Wildcard lookup: 2:56
Wildcard filtering: 4:54
Ends with: 5:25
Question mark: 6:00
Question mark and Asterisk: 7:04
Find and replace: 7:49
Tilde: 9:21
Limitations of wildcard characters: 10:09
  1. Alex Sington
  2. Excel
  3. Wildcard Characters
  4. Tutorial
  5. Data Analyst
Рекомендации по теме
Excel Wildcard Characters 0:11:09

Excel Wildcard Characters | Tutorial + Examples

Excel Wildcard Characters 0:10:47

Excel Wildcard Characters in Formulas

Wildcard in Microsoft 0:25:48

Wildcard in Microsoft Excel| Use in Formulas, Filters and Find & Replace | Complete tutorial

How to Use 0:01:00

How to Use Wildcard Characters in Excel

How to use 0:06:10

How to use wildcard characters in excel examples Excel tutorial 2021

wildcard in excel 0:00:18

wildcard in excel

How to Use 0:12:56

How to Use Wildcard Characters in Excel (Examples)

😲 Power full 0:00:15

😲 Power full wildcard in excel Shortcut #shorts #excel #shortsvideo #shortstranding #hack

Correct method to 0:00:27

Correct method to replace a wildcard character in Excel

How to use 0:05:00

How to use Wildcard with If Function in Microsoft Excel | Learn in 5 Minutes

Did you Know 0:00:57

Did you Know the Wildcard Feature in Excel?

How to Remove 0:01:41

How to Remove Wildcard Characters in Excel Using Find & Replace – Tutorial

How to Use 0:08:53

How to Use Wildcard Characters in Excel with Examples

Using Wildcard in 0:00:54

Using Wildcard in Excel - Excel Tips and Tricks

Excel wildcard (asterisk): 0:00:22

Excel wildcard (asterisk): find and replace easily

Searching data using 0:00:49

Searching data using WILDCARD characters using XLOOKUP function in excel

Filter Function Wildcard 0:04:03

Filter Function Wildcard Match in Excel

Excel Wildcard IF 0:04:34

Excel Wildcard IF - NOT WORKING! | If Cell Contains Text Then...

Use Wildcard Character 0:01:00

Use Wildcard Character in Excel & GET Amazing Results

Excel Wildcard Function 0:00:59

Excel Wildcard Function | A Beginner's Guide to Using Wildcards for Efficient Data Analysis

XLookup Wildcard Match 0:02:42

XLookup Wildcard Match in Excel

How to Use 0:11:09

How to Use Wildcard Characters in Excel

Excel SUMIFS Function 0:00:30

Excel SUMIFS Function Wildcard

Use a wildcard 0:00:41

Use a wildcard in a formula to act as a 'Contains' operator!

Комментарии
Автор

Very clear and very thorough explanation. Based on my experience many users are not aware of the search bar in the Table filter dropdown let alone how t use it!

richardhay
Автор

wow ur the best, really highly appreciated ur efforts, keep doing great work

rajasekhar
Автор

I wonder why MS did not use the industry standards (a.k.a. regex) for their wildcard characters? Instead of the tilde, they should have used the more oft-used backslash escape symbol, IMHO.

msheaver