merryperson
Board Regular
- Joined
- Apr 27, 2005
- Messages
- 72
Good afternoon and I have a problem which I am sure is simple to sort out if you know how.
I have a list of filler from iTunes and I am trying to see what music collection I have and I have a s
cell in excel showing the following information which is repeated for each track
I want to split the text so I just get the text after the /Volumes/Itunes library/ so I get the words starting Various Artist as this will be the name of the artist and is always after the / in library
is there a formula I can use to do this please
Thanks
I have a list of filler from iTunes and I am trying to see what music collection I have and I have a s
cell in excel showing the following information which is repeated for each track
I want to split the text so I just get the text after the /Volumes/Itunes library/ so I get the words starting Various Artist as this will be the name of the artist and is always after the / in library
is there a formula I can use to do this please
Thanks