Excel – Remove All Text After Specified Character
Posted: June 10th, 2011 | Author: jriggs | Filed under: excel, windows | 1 Comment »This excel function searches the cell ‘V22′ for the ‘greater than’ character. If it is found then it will remove that character and everything after it. If not found then it will copy V22′s value.
=IF(ISNUMBER(SEARCH(">" , V22)) , LEFT(V22,FIND(">",V22,1) - 1) , V22)