I have a data set with 5 types of entry that begin with <xxxx>value i want</xxxx>. What I'd like to do is have an if statement that determines what the xxxxx type is and then returns the value between the >< marks. I've got the if statement part figured out, but I cant figure out how to extract the internal value/trim the tail because the number of characters varies.

Please see attached for further clarification

if_statement_results_between_chars.xlsx

Thank you!