I have a description field that has the following:
<!A>Description of Product
<!B>Description of Next Product
<!C>Description of Third Product
I'm wanting to put in a formula where if the description field contains "<" then I want to trim the first 4 characters. If there is no "<" at the beginning then do nothing. So in essence I want to just remove the "<!A>","<!B>","<!C>"