View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
billinr billinr is offline
external usenet poster
 
Posts: 38
Default Extract text between symbols

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