Split first middle and last name by using formula in excel hindi

Teachtoeach presents a wonderful video “how to split first middle and last name by using formula in excel hindi”.This excel tutorial explains you extract first, middle and last name in excel syntax with example.

With the help of this video you can use-:

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

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

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

To extract these name we must use some functions which is mention below:-

1) LEFT() - is used to extract substring from a string side , starting from the left-most character.

Syntax of LEN -

2) RIGHT() - is used to extract substring from a string side , starting from the right-most character.

Syntax of RIGHT - RIGHT( text, [number_of_characters] )

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

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

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

Syntax of LEN - LEN( text )

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

Syntax of FIND - FIND( substring, string, [start_position] )
How to divide first and last name in excel:-

A) To extract first name we use – Len formula with find formula.

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

C) To extract last name we use – Right 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 first middle last 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) Use of hlookup with match formula in excel in hindi -    • Hlookup Match formula in Excel Hindi  

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

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

4) How to make speedometer in excel hindi -    • How to make a speedometer in excel hindi  

5) Excel datedif formula in hindi -    • Datedif Formula in Excel Hindi  

6) Excel countifs formula in hindi -    • Countifs Formula in Excel Hindi  

7) How to use sumproduct formula in excel -    • Sumproduct Formula in Excel Hindi  

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

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

10) Reverse Lookup Formula Vlookup with Choose Function in Excel -    • Reverse Lookup Formula Vlookup with Choose...  

11) 2D-Two Dimensional Lookup Formula Vlookup with Match in Excel -    • 2D-Two Dimensional Lookup Formula Vlookup ...  

12) How to consolidate multiple worksheets into Pivot Table -    • How to consolidate multiple worksheets int...  

13) How to use Vlookup formula in Excel 2013 Hindi By TeachToEach -    • Vlookup Formula in excel hindi  

14) Mail Merge in Word -    • Use of Mail Merge in Hindi