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)

6 responses to “Excel – Remove All Text After Specified Character”

  1. You could also do a simple find/replace as well.

    Just do a find for “>*”, leave the replace empty and do “Replace All”.

Leave a Reply

Your email address will not be published. Required fields are marked *