On Mon, 30 Apr 2007 15:59:04 -0400, Ron Rosenfeld
wrote:

On Mon, 30 Apr 2007 12:12:01 -0700, 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

If the strings are less than 256 characters long, then you could download and
install Longre's free (and easily distributable) morefunc.xll add-in from
http://xcell05.free.fr/.

Then use this formula:

=REGEX.MID(A1,"(?<=/).*?(?=/)")


--ron

Oh, for the text after the second "/"

=REGEX.SUBSTITUTE(A1,".*/.*/")
--ron