Saved Bookmarks
| 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, |
|