Extracting the First Word of a String with ISERR : LEFT « Text functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Text functions
  3. LEFT
Input the formula: =IF(ISERR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1))
Input the formula: =IF(ISERR(FIND








22.11.LEFT
22.11.1.LEFT(text,num_chars) returns the leftmost characters from a text valueLEFT(text,num_chars) returns the leftmost characters from a text value
22.11.2.=LEFT(A3)=LEFT(A3)
22.11.3.Get count of characters where the space is from left.Get count of characters where the space is from left.
22.11.4.Extracting the First Word of a StringExtracting the First Word of a String
22.11.5.Extracting the First Word of a String with ISERRExtracting the First Word of a String with ISERR