Загрузка...

Lec-17: Text Functions In Excel 2025- LEFT, MID, RIGHT, CONCAT ... with Examples | Excel Basics

📌 Welcome to this video of our Excel Basics 2025 Series!
Aaj ke video mein hum seekhne wale hain Excel ke kuch must-know text functions –
jo help karte hain text data ko extract, clean aur format karne mein! 🧠💻

LEFT, MID, RIGHT, LEN aur CONCAT –
yeh functions aapko student IDs, names, aur email lists handle karne mein expert bana denge! ✅

🎯 Perfect for:
Students, beginners & Excel users jo daily kaam karte hain text-based data ke saath –
jaise roll numbers, full names, ya email generate karna.

📊 In this video, you’ll learn:
🔹 What is LEFT, MID & RIGHT – and how to extract parts of a string
🔹 LEN function – to count total characters in a cell
🔹 CONCAT – to join names & create email IDs
🔹 Real-life example: CSE-2025-A45 ID breakdown
🔹 Use of CONCAT with dot + @ – email creation made easy
🧠 Bonus: Validation tip using LEN to catch wrong entries

🗂️ Worksheet Example Includes:
• Student ID extraction table
• First Name + Last Name → Full Name
• Email ID creation using CONCAT
• LEN function to check valid/invalid IDs
• Common errors beginners karte hain while using MID & RIGHT

🗣️ Language: Hindi + Easy English (Hinglish)

🔔 Subscribe to Tech Hub For Students & bell icon zarur dabao –
taaki Excel ke formulas aur tricks aap miss na karo!

📤 Share this video with apne classmates, interns, ya office colleagues –
jo text copy-paste se kaam chalate hain. Ab seekho smart text formulas!

📂 Watch the Full Playlist:
🔗 Excel Basics 2025 – Full Course for Beginners

👇 End tak zaroor dekhna — CONCAT with email logic sabse important hai! 👇

🔖 Tags:
#ExcelTextFunctions #LEFTMIDRIGHT #LENFunctionExcel #CONCATExcel #StudentIDExcel
#ExcelBasics2025 #ExcelTutorial #ExcelInHinglish #ExcelForBeginners #TechHubForStudents

Видео Lec-17: Text Functions In Excel 2025- LEFT, MID, RIGHT, CONCAT ... with Examples | Excel Basics канала Tech Hub For Students
Яндекс.Метрика

На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.

Об использовании CookiesПринять