filmov
tv
Excel Interview Question - Extract Middle Name by MID Formula.
![preview_player](https://i.ytimg.com/vi/Q0CTIE8eT-4/maxresdefault.jpg)
Показать описание
#sandy-tech #sandy-tech-1992
Excel Interview Question - Extract Middle Name by MID Formula. There is small range of Full Name in excel we have written text formula (MID ()) to extract middle name. Please find below formula-
=MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1)-FIND(" ",A2))
Previous video :-
Thanks .......
Excel Interview Question - Extract Middle Name by MID Formula. There is small range of Full Name in excel we have written text formula (MID ()) to extract middle name. Please find below formula-
=MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1)-FIND(" ",A2))
Previous video :-
Thanks .......