Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Extracting the First Word of a String

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