Text Functions MSOfficeExcel 2007 Tutorial

Input the formula: =IF(ISERR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1))