View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RSCARLISLE RSCARLISLE is offline
external usenet poster
 
Posts: 3
Default nth element extract

How do I extract the nth element of a string that contains no separators? I
can find plenty of VB routines doing this, however all of them require some
sort of separator. I want to be able to take a 10 to 15 digit alphanumeric
string and identify each character position and read the charater in that
position (including using * as a wild card).