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)
Great post, I believe people should larn a lot from this weblog its real user friendly. So much excellent info on here :D.
You could also do a simple find/replace as well.
Just do a find for “>*”, leave the replace empty and do “Replace All”.