Hi Paula

Try
=MID(A1,FIND("/",A1)+1,FIND("^",SUBSTITUTE(A1,"/","^",2))-1-FIND("/",A1))

--
Regards
Roger Govier



"Paula" wrote in message
...
This is I'm sure a simple formula, I have a cell entry which is like
13543/t125790/INT

This represents 3 different pieces of data, I have used left and right
formulas to get the beinning and end of the entry into two separate cells,
I
now need to get the middle entry T125790 into a cell of it's own. How do I
do
this?