View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] exocet.am39@gmail.com is offline
external usenet poster
 
Posts: 6
Default Extracting Text between 2nd and 3rddelimiter

hi,

i have the following text:

AAA_llac_MAR_99_eg

i am trying to write a formula to extract the text between the second
and third occurance of '_" (the delimiter). Basically i want to
extract MAR. I am trying to do this using the MID and FIND statement.

Any help would be appreciated!

db