I am trying to get the middle Name from below mentioned Name by using Excel Formula-
Ram Kumar Singh
Manish Kumar Rana
Danish tomar Singh
Kindly note that the formula should be dynamic so that when we drag the form till last row we should be able to get the Middle Name.
Anuj Kumar 28 Aug 2017 0 0
=MID(A1,FIND(" ",A1,1)+1,FIND(" ",A1,FIND(" ",A1,1)+1)-FIND(" ",A1,1)-1)
I am able to solve below problem in below way. Please have a look:
First I have separated (first+middle) from full name using left function.
Then I have separated middle name using right function.
First+Middle=LEFT(B2,FIND(" ",B2,FIND(" ",B2,1)+1)-1)
Middle: =RIGHT(D2,LEN(D2)-FIND(" ",D2,1))
It looks like below: