Separating Strings

[Guest]

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

 

[Guest]

You can cycle through the code using INSTR to find the segments containing
slashes.

 

[David McRitchie]

Your question is unclear, normally when asked to separate a string
it goes onto the same row. But since you are placing the results
in three rows the example becomes very ambiguous.

Is it just a Column that exists and is going to generate
2 additional rows or will the number of substrings vary. Is it only
once cell that you are going to start with. When you program something
you have to have things clearly defined before starting (well at least
you're supposed to in theory), because the program is going to do
exactly what you ask it to do (even if you don't know what you told it to do)..

 

[Tom Ogilvy]

v = split(sStr,"\")
for i = lbound(v) to ubound(v)
msgbox v(i)
next

 

[Guest]

Thanks guys (especially Tom)

Finally found that function in the appendix of J. Walkenbachs book