Separating Strings

A

asmenut

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
 
G

galimi

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

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)..
 
A

asmenut

Thanks guys (especially Tom)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top