Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Extracting the First Word of a String with ISERR

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