Category: excel

  • Excel – Remove All Text After Specified Character

    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)