Separating Strings

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)..
 
Thanks guys (especially Tom)

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