Select text between two characters

Use the following formula, assuming your data is in cell A2

=mid(left(A2,find(">",A2)-1),find("<",A2)+1,len(A2))

To avoid error message if your data is not conforming, you can use the following in excel 2007 and up:

=iferror(mid(left(A2,find(">",A2)-1),find("<",A2)+1,len(A2)),"")