Split data from one excel cell file into 2 columns

Hello,

I am dealing with an excel column that you could see below where I would like to spit it in two different columns one that includes the text before the / and one that includes the text after the /?

Is there an easy way to do that?

Thanks in advance

Greg

[Alex Mcaulley]

Take a look to split

[Grigorios Kyritsakas]

Thanks, that's helpfull

[Bob Thompson]

If you are importing the information as a group of strings you can also look at regexp.

[Guillaume]

I don't know about split since you can't see its code (at least the useful part), but the older strsplit is just a wrapper for regexp, so they're pretty much equivalent anyway. split/strsplit has the advantage you don't need to learn regular expressions.

[Bob Thompson]

I might be slightly bias, but I think that if you spend any amount of time regularly working with strings in Matlab it is totally worth it to learn regexp. There is definitely a bit of a learning curve, but it's such a useful tool. strsplit is definitely easier to pick up and use in a pinch though.