View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_2_] Robert Crandal[_2_] is offline
external usenet poster
 
Posts: 158
Default Alternate ways to extract a substring?

I have the following simple code:

sTxt = Mid(sSentence, 14, 5)

This code copies 5 characters from the string contained
in the variable "sSentence", starting at position 14.

My question is, is there another way to do the same
exact thing WITHOUT using the "Mid()" function???

I'm basically trying to find other ways to extract substrings
without using the MID() function.

Thank you!

Robert Crandal