Tip Printed from ExcelTip.com
Return text up to the second space in Microsoft Excel



Text :             George W. Bush

The Function:   
      =LEFT(A5,FIND("*",SUBSTITUTE(A5," ","*",LEN(A5)-LEN(SUBSTITUTE(A5," ",""))))-1)

Result:               George W.