1.

Excel formula fto find second space from right

Answer»

IF(ISERROR(FIND(" ",A2,FIND(" ",A2,1)+1)),A2,LEFT(A2,FIND(" ",A2,FIND(" ",A2,1)+1))) into a BLANK cell where you want to locate the RESULT,



Discussion

No Comment Found

Related InterviewSolutions