Left, Right, Mid, Len, Find and Concatenate Function

This tutorial contains 6 MS Excel simple but very powerful functions.
You will learn Left function, Right function, Mid Function, Len function, Find function and concatenate function in this one video.
These 6 functions of ms excel or simple but very powerful and highly useful functions.
For more awesome and useful ms excel and ms word relating tutorials please visit and subscribe out channel "Microsoft Office Tutorials" at
/ microsoftofficetutorials
Also follow us on our Facebook pages as below,
Excel Expert
/ excelxpert
MS Word - Basic to Advance Level
/ mswordbasictoadvance
Microsoft Office Tutorials
/ msofficetutorials
Here are some links to awesome ms excel tutorials
Highlight Duplicate Rows in Excel (Compare Data in Excel)
• Highlight Duplicate Ro...
How to find Duplicates in excel (2 Methods)
• How to find Duplicates...
SUM, SUMIF and SUMIFs Excel (Tutorial and Comparison of Functions)
• SUM, SUMIF and SUMIFs ...
How to Remove forgotten Excel Password (Full Tutorial) 2018
• How to Remove forgotte...

[@hirwajeanclaude5871]

Thank you 🙏🙏🙏, this was really helpful

[@alexanderazarov2105]

great video

[@nasratullahayoubi9403]

Thumbs up man for you what a legend you are thanks for making the video 👍

[@abhilash4444]

Bhai Hindi may samjadey

[@MicrosoftOfficeTutorials]

Abhilash, hindi maen Excel seekhny k liye ap hmara dusra youtube channel subscribe kr sktay hain.
Channel Name: Urdu Hindi Lectures
Address:
RUclips.com/UrduHindiLectures

[@manishsahoo-m5j]

how can we extract "3digit number " from a cell say "123-4567-432"

[@MicrosoftOfficeTutorials]

From where exactly you want to Extract exactly the 3 digit number? From Left, Right or middle?

[@Peter-jp9pn]

This was a very clear and thorough explanation of a variety of the major field editing functions. It was just what I needed.

[@MicrosoftOfficeTutorials]

❤

[@adebiyigbeminiyi418]

Very great video 🎉🎉

[@shivanijaiswal9220]

sir, why haven't you uploaded the sheet for practice? It would be great if you upload the sheet which you have shown in the video.

[@Avnish715]

Superb sir

[@sohelahmadkhan1775]

it is useful

[@manuelremusstanca5539]

How am I supposed to extract only the first letter of the last name and given name? If I have a middle name what is the best choice to do it? Thx

[@MicrosoftOfficeTutorials]

Use text to column to separate last name then use right function to get first letter of last name....
Please let me know if you need further clarification we can discuss

[@ongbobby6626]

Simple and easy explanation. Thank you

[@siddavatum]

PLEASE EXCPLAIN HOW TO CALCULATE RIGHT+LEFT+MIDDLE VALUES IN ONE CELL IE (3+3+3) IN ONE CELL

[@MicrosoftOfficeTutorials]

Use & between these 3 functions

[@urielwise1398]

Very helpful
Thank you

[@priyajadhav28]

Where to download this excel sheet for practise?

[@sudharsanak4353]

Thanks ,very nearly explained ।
Will।be obliged if you can explain if and right function together ।।

[@carlos369pro5]

Very useful information 😁

[@jacobdahlman626]

You're a champ!

[@MicrosoftOfficeTutorials]

Thanks 😊

[@radhikayadav3259]

Right left ka Mahabharat kyu bata rhe bhai

[@mdkhalidrahman2832]

thanks 🎉

[@rafaelaprende]

Thank you

[@tawsifislam9484]

Well explained...very good video .. keep up the good work ....

[@MicrosoftOfficeTutorials]

Thanks a lot :)

[@Wo1f]

i hate the audio but the info is top tier