View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
galimi[_2_] galimi[_2_] is offline
external usenet poster
 
Posts: 65
Default Separating Strings

You can cycle through the code using INSTR to find the segments containing
slashes.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"asmenut" wrote:

I have a String (actually a few of them) that are combined with a "/"
separator (i.e. String1 / String2 / String3). How would I go about reading
the string and separating the individual strings from them like:

String1
String2
String3

Thanks in advance