MS-EXCEL-42-How to use Wildcard Character in Excel | Find and Replace with Wildcard Character |Hindi

Published: 29 May 2023
on channel: Mr Coding
909
50

*How to use Wildcard Character in Excel* | Find and Replace with Wildcard Character |Hindi


MS-EXCEL-41-Excel मे Find and Replace के साथ वाइल्डकार्ड का उपयोग

Hi,
Welcome to Mr. Coding Channel to learn something new.
In this video, we are going to learn How to use wildcard characters in Excel with the Find and Replace option.
In Excel, there are three types of wildcard characters.
* Asterisk
? Question mark
~ Tilde

When to use " * " (asterisk)?
find or replace any character and any number of character

When to use " ? " (Question mark)?
find or replace any character and given number of character

When to use " ~ " (tilde)?
to remove the wildcard effect from " * " and " ? "


⌚ Timestamps | Time-Line | Chapters
00:00 - What Do We Learn?
01:41 - When to use a wildcard character?
02:17 - Use of " * " (asterisk) | Example 1
05:49 - Use of " * " (asterisk) | Example 2
07:38 - Use of " * " (asterisk) | Example 2
08:38 - Use of " ? " (Question Mark) | Example
11:11 - Use of ~ (Tilde) | Example




Download the file
MS Excel Part 042 - Exercise for Practice - Visit to download
प्रेक्टिस करने के लिए एक्सरसाईझ - डाउनलोड करे

--------------------------------------

--------------------------------------
Related Video
Excel Tutorial Playlist | All Parts

-------------------------------------



MS Excel Tutorial Playlist

-----------
MS Word Tutorial Playlist

-------------
Tally Tutorial in Gujarati

-------------
Our FaceBook

-------------
Our Instagram

-------------
Join Our Telegram Channel

-------------
Official Website

-------------



Watch video MS-EXCEL-42-How to use Wildcard Character in Excel | Find and Replace with Wildcard Character |Hindi online without registration, duration 15 minute 26 second in high hd quality. This video was added by user Mr Coding 29 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 909 once and liked it 50 people.