Split Middle Name in Excel Hindi | How to extract middle name in excel

Teachtoeach presents a wonderful video “how to split middle name in excel in hindi”.This excel tutorial explains you how to extract middle by using formula in excel hindi.

With the help of this video you can use-:

1) Split middle name in excel 2003,2007,2010,2016 by using formula

2) Split First name in excel 2003,2007,2010,2016 by using formula

3) Split last name in excel 2003,2007,2010,2016 by using formula


1) MID() - is used to extract substring from a string.

Syntax of MID - MID( text, start_position, number_of_characters )

2) LEN() - is used to count the number of character in cell.

Syntax of LEN - LEN( text )

3) FIND() –function returns the location of a substring in a string.

Syntax of FIND - FIND( substring, string, [start_position] )

A) To extract middle name we use – Mid formula with find formula.

It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down.

On youtube, only just few videos are available on split middle excel in hindi formula.

Thanks for watching this excel hlookup tutorial in hindi video. It is humble request to you please subscribe my Channel.

   / teachtoeach  

Some popular videos-:


1) How to add 0 zero before number in excel hindi -    • How to add 0 zero before number in excel h...  

2) Excel Interview Questions | MIS Interview Question | Excel in Hindi -    • Excel Interview Questions | MIS Interview ...  

3) Insert Blank Row After Each Row | Add Blank Column Between in excel in hindi -    • Insert Blank Row After Each Row | Add Blan...  

4) Excel Interview Questions | MIS Interview Questions | Excel in Hindi -    • Excel Interview Questions | MIS Interview ...  

5) Calculate Age in Excel Hindi -    • Calculate Age in Excel Hindi  

6) Pareto chart in excel hindi -    • Create Pareto Chart in Excel Hindi  

7) Drop down list from Different Workbook in Excel in Hindi -    • Drop Down List from Different Workbook in ...  

8) Pivot Table in Excel in Hindi -    • Pivot Table in Excel in Hindi  

9) Create and Remove drop down list in excel in hindi -    • Create and Remove Drop Down List in Excel ...  

10) Vlookup with Indirect Function in Excel Hindi -    • Vlookup with Indirect Function in Excel Hindi  

11) Fuzzy Lookup in Excel Hindi -    • Fuzzy Lookup in Excel Hindi  

12) Text To Column in Excel in Hindi -    • 🔥 Text To Column in Excel in Hindi 🔥 | How...  

13) Vlookup with Match Function in Excel Hindi -    • Vlookup with Match Function in Excel Hindi  

14) Randbetween Formula in Excel in Hindi -    • Randbetween Formula in Excel in Hindi  

15) Sort Left to Right in Excel Hindi -    • Sort Left to Right in Excel Hindi  

16) Double Vlookup in Excel Hindi Part-2 -    • Double Vlookup in Excel Hindi | Part 2  


17) Array Formula in Excel Hindi -    • Array Formula in Excel Hindi  


18) Excel vlookup formula error #NA #REF #VALUE in hindi -    • Excel Vlookup Formula Error #NA #REF #VALU...  


19) 3 Tips to make easy Vlookup Formula in Hindi -    • 3 Tips to make easy Vlookup Formula in Hindi  


20) Concatenate Formula in Excel Hindi -    • Concatenate Formula in Excel Hindi  

21) Double VLOOKUP in Excel Hindi -    • Double Vlookup in Excel Hindi  

22) Split first middle and last name by using formula in excel hindi -    • Split first middle and last name by using ...  

23) Create Dependent Drop Down List in Excel Hindi -    • Create Dependent Drop Down List in Excel H...  

24) How to make a picture lookup in excel -    • How to create a picture lookup in excel hindi  

25) Relative Absolute and Mixed Cell Referencing in Excel -    • Relative Absolute and Mixed Cell Referenci...  

26) Excel Logical Functions IF AND OR NESTED IF in Hindi -    • Excel Logical Functions  IF AND OR NESTED ...