Excel Interview Question - Extract Middle Name by MID Formula.

preview_player
Показать описание
#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 .......
Рекомендации по теме