Dear all,
I want to retrieve particular text string in between >X</ by excel formula.

Some example below, Cell A having some data in in between > X </ , from here I want to get data like Cell B ( "X" data required) 

CELL A                               CELL B

<mtu>1500</mtu>                      1500