Thank you. This worked well for the text between the symbols.
Could you offer something that would find the text after the second "/"?

TIA

"Ron Coderre" wrote:

With text in cel A1

Try something like this:
B1: =LEFT(MID(A1,FIND("/",A1)+1,255),FIND("/",MID(A1,FIND("/",A1)+1,255))-1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"billinr" wrote:

I would like to extract text from a string which will contain:

<sometext/the text I want/<sometext

The beginning and ending text will vary in length, but the text I want will
be between the two "/".

I am also looking to extract the text after the second "/", in a different
operation.

The data will change, so I want to write this as a template.

Any help is appreciated.

Thanks