excel formula fto find second space from right
Answers
Answered by
0
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,
Similar questions
Computer Science,
8 months ago
English,
8 months ago
Hindi,
1 year ago
Math,
1 year ago
Math,
1 year ago