How to use TRIM function to remove extra space & SUBSTITUTE to replace characters in Excel ? 82

In this basic hindi tutorial of Microsoft Excel 2016/2013/2010/2007 you will learn how to use Trim and Substitute function.
Trim Function/Formula removes extra spaces present before, after or between the words.
And, the Substitute Function/Formula is used to replace some alphabets, numbers, or special characters of the text with other alphabets, numbers, or special characters.

Microsoft Excel 2016/2013/2010/2007 ki is basic hindi tutorial me aap Trim aur Substitute function ka upyog karna sikhenge.
Trim Function/Formula, shabdon ke pehle, baad mein ya bich mein upasthit extra space ko hata deta hai.
Aur, Substitute Function/Formula, text ke kuch alphabets, numbers ya special characters ko anya alphabets, numbers ya special characters se badalne ke liye upyog mein laya jata hai.

Microsoft Excel 2016/2013/2010/2007 की इस बेसिक हिंदी ट्यूटोरिअल में आप trim और substitute function का उपयोग करना सीखेंगे |
Trim Function/Formula, शब्दों पहले ,बाद में या बीच में उपस्थित एक्स्ट्रा स्पेस को हटा देता है |
और, Substitute Function/Formula, टेक्स्ट के कुछ अल्फाबेट्स, नंबर्स या स्पेशल characters को अन्य अल्फाबेट्स, नंबर्स या स्पेशल characters से बदलने के लिए उपयोग में लाया जाता है |

Exercise File :
Subscribe :
MS Excel Playlist :
All Playlist :
Website :

microsoft excel,Microsoft Excel 2016 tutorial,ms excel 2016,MS excel,ms office,excel 2016,excel,Excel help,Excel in Hindi,Spreadsheet,learn excel,learn excel in Hindi,learn ms excel,gyanyagya,in hindi,Tutorial,beginners,how to,trim formula in excel in hindi,substitute formula in excel in hindi,trim function,substitute function,remove extra space from words using trim formula,substitute function to replace characters,