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

Also follow us on our Facebook pages as below,

Excel Expert

MS Word - Basic to Advance Level

Microsoft Office Tutorials

Here are some links to awesome ms excel tutorials

Highlight Duplicate Rows in Excel (Compare Data in Excel)

How to find Duplicates in excel (2 Methods)

SUM, SUMIF and SUMIFs Excel (Tutorial and Comparison of Functions)

How to Remove forgotten Excel Password (Full Tutorial) 2018

[nasratullahayoubi]

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

[Peter-jppn]

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

[hirwajeanclaude]

Thank you 🙏🙏🙏, this was really helpful

[ongbobby]

Simple and easy explanation. Thank you

[sudharsanak]

Thanks, very nearly explained ।

Will।be obliged if you can explain if and right function together ।।

[shivanijaiswal]

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.

[Wof]

i hate the audio but the info is top tier

[tawsifislam]

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

[siddavatum]

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

[manuelremusstanca]

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

[priyajadhav]

Where to download this excel sheet for practise?

[qnmxojv]

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

[radhikayadav]

Right left ka Mahabharat kyu bata rhe bhai