View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kirk[_2_] Kirk[_2_] is offline
external usenet poster
 
Posts: 17
Default Grabbing a String between two delimiters

For some reason I can't seem to figure this one out. I
need to be able to determine a string that lies between
two delimeters.

Example:

xyz\abc\defgh

I need to be able to grab out the "abc" portion without
knowing the exact size of what the string will be between
the two delimters (\). In looking at a book I have there
was mention of a function called dhExtractString but it
appears not to work on Excell 2002 (SP2) unless there is
a reference that I need to add.

Any help would be appreciated. Thanks.

Kirk