View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tatsujin Tatsujin is offline
external usenet poster
 
Posts: 25
Default Extract segments of an array

Cool! That pattern works!

But how do you test when no matches are found? I think it's returning the last element of the array when I search for a letter not in the array, such as "x".