View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Jay Dean Jay Dean is offline
external usenet poster
 
Posts: 154
Default EXTRACTING SUBSTRINGS !!

Actually, I now see that your code will be the one to use because the
3rd argument specifies "how many strings to return". With my needing the
first 4, everything else will be stored in the 5th (Leftover).

Man, the SPLIT() function is really powerful. Thanks again, Rick !


Jay

==============================================
Rick wrote:
Just out of curiosity, why wouldn't you use the 3rd argument approach
for
this part of your application as well (given that it eliminates the need
for
a loop altogether)?

========================================



*** Sent via Developersdex http://www.developersdex.com ***