How to separate full name in Excel | Excel mein naam ko alag kaise kare | Remove symbols in text

Hi I am Abhishek Jaiswal. Welcome to our YouTube channel @guideofmad About this video- ⭐ Description Start (Keyword Focus + Value Explanation) Is video me aap sikhenge ki Excel Power Query Editor aur Text Query functions ka use karke data ko kaise professional way me clean kiya jata hai. Yeh tutorial Excel users, data analysts, Power BI learners sabhi ke liye perfect hai. Is video me hum Trim, Clean, Case Change, Prefix–Suffix remove/add, Delimiter ke saath extract operations, aur character extraction jaise functions ko practical example ke saath cover karenge. 🧩 What You Will Learn (Step-by-Step Sections) 1. Power Query Editor Basics Power Query Editor ka introduction Data import & preview applied steps kaise work karte hain Power Query aur Excel Text functions ka comparison 2. Text Cleaning Functions in Excel & Power Query ✔ Trim & Clean Function Extra spaces remove karna Invalid characters clean karna Power Query me Trim & Clean transform karna ✔ Case Change Upper Case Lower Case Capitalize Each Word (Proper Case) Transform tab me case formatting options ✔ Prefix & Suffix Prefix add/remove Suffix add/remove Custom rules for text formatting ✔ Text Before Delimiter Dash (-), comma (,), @, space ya kisi bhi delimiter se pehle ka text extract ✔ Text After Delimiter Delimiter ke baad aane wala text extract ✔ Text Between Delimiter Start aur End delimiter ke beech ka data extract ✔ First Character Extraction First character / first digits output ✔ Last Character Extraction Last letter / last digits extract ✔ Text Range Extraction Text.SplitRange Mid-like extraction using Power Query M functions 3. Use First Row as Header Power Query me "Use First Row As Headers" Header cleanup & formatting 4. Excel vs Power BI Same Power Query Editor Power BI me bhi use hota hai Ek hi workflow Excel aur Power BI dono me apply 5. Final Data Cleaning Output Completely cleaned data table Structured data ready for analysis Best practices for data preparation 🎯 Why This Video is Important? Data cleaning is the first step of data analysis Power Query Editor is used in Excel + Power BI Zero-code transformations for beginners Professional text cleaning workflow Thank you So much. Queries Solve : - How to separate full name in Excel , Excel mein naam ko alag kaise kare , Remove symbols in text ,Last name and first name ko alag kaise kare Excel mein , How to merge text values ,text before/after How to extract text with @ in Excel , , se text alag kaise kare , text cleaning & name split tutorial ………………………………………………………………………………………………………………………………… Other Channel links Guide of mad - Excel    / @guideofmadexcel   Our social Links-   / funofexcel     / guideofmad_   Thanks for watching Don't forget to - LIKE 👍 | SHARE 🤗 | COMMENT 💁 | SUBSCRIBE 🤓 YouTube -    / guideofmad   #datatips #guideofmad #abhishekjaiswal #dataanalytics #ExcelTutorial #PowerQuery #DataCleaning #ExcelTips #PowerBI #DataAnalysis #ExcelFunctions #LearnExcel #ExcelTraining #PowerQueryEditor