Description
Easiest Way to SPLIT Name in Excel | Extract First Name MID Name Last Name in Excel
Teachtoeach presents a wonderful video how to split name in excel. 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 how to split name in excelvideo. It is humble request to you please subscribe my Channel.
Some popular videos-:
1) How to add 0 zero before number in excel hindi - https://www.youtube.com/watch?v=LahJ0RwqwcQ
2) Excel Interview Questions | MIS Interview Question | Excel in Hindi - https://www.youtube.com/watch?v=f53IPkk-VJA
3) Insert Blank Row After Each Row | Add Blank Column Between in excel in hindi - https://www.youtube.com/watch?v=93TCmTiI4rs
4) Excel Interview Questions | MIS Interview Questions | Excel in Hindi - https://www.youtube.com/watch?v=ilVB2ci_Ro8
5) Calculate Age in Excel Hindi - https://www.youtube.com/watch?v=eb251Ob5L0g
6) Pareto chart in excel hindi - https://www.youtube.com/watch?v=U2hLI-bqZQg
7) Drop down list from Different Workbook in Excel in Hindi - https://www.youtube.com/watch?v=HFpAQ5lRG04
8) Pivot Table in Excel in Hindi - https://www.youtube.com/watch?v=0TzBd2rcmDk
9) Create and Remove drop down list in excel in hindi - https://www.youtube.com/watch?v=rlFbMOYqerk
10) Vlookup with Indirect Function in Excel Hindi - https://www.youtube.com/watch?v=G5QrMl5UQeU
11) Fuzzy Lookup in Excel Hindi - https://www.youtube.com/watch?v=SmXOXhNRZKY
12) Text To Column in Excel in Hindi - https://www.youtube.com/watch?v=kQsplwm9xbo
13) Vlookup with Match Function in Excel Hindi - https://www.youtube.com/watch?v=ALZ2y2rK-Pw
14) Randbetween Formula in Excel in Hindi - https://www.youtube.com/watch?v=0V_nR_8I-Xo
15) Sort Left to Right in Excel Hindi - https://www.youtube.com/watch?v=k9mPhyR1Iak
16) Double Vlookup in Excel Hindi Part-2 - https://www.youtube.com/watch?v=D2Oq6KxBJ2A
17) Array Formula in Excel Hindi - https://www.youtube.com/watch?v=3hJKSXf5kRE
18) Excel vlookup formula error #NA #REF #VALUE in hindi - https://www.youtube.com/watch?v=JlF8amcQS2A
19) 3 Tips to make easy Vlookup Formula in Hindi - https://www.youtube.com/watch?v=HxfPY872VCg
20) Concatenate Formula in Excel Hindi - https://www.youtube.com/watch?v=86oaZNDzeD8
21) Double VLOOKUP in Excel Hindi - https://www.youtube.com/watch?v=12KuchYnJPw
22) Split first middle and last name by using formula in excel hindi - https://www.youtube.com/watch?v=FJS8yKgnCkM
23) Create Dependent Drop Down List in Excel Hindi - https://www.youtube.com/watch?v=Z1mb1qG75e8
24) How to make a picture lookup in excel - https://www.youtube.com/watch?v=y84-JXdJSUQ
25) Relative Absolute and Mixed Cell Referencing in Excel - https://www.youtube.com/watch?v=R3GEbagnbp4
26) Excel Logical Functions IF AND OR NESTED IF in Hindi - https://www.youtube.com/watch?v=Us1wr2QrrlM
Topics Include : split name in excel,text to columns,full name split automatic in exce,teach to each,teachtoeach,name split in excel,excel,full name to 1st name middle name and last name,learn excel,sheet design,middle name first name and sur name,word,sheet,excel sikhe,excel sheet,double vlookup in excel,what is power bi,sql tutorial in hindi
#Excel
#dataanalysts
#sql
#powerbi