Why not just apply Find & Replace ?
Find What: <*>
Replace With: leave blank
(Copy B to A and apply above if needed)
edit: - if you are adamant you want a formula
A1: =IF(LEFT(B1)="<",REPLACE(B1,1,FIND(">",B1),""),B1)
assumes where there's > there's <
Bookmarks