I am trying to create some csv files in excel to use to auto edit some mp3 file id3 tags.
I have the track date in one cell in excel in the format
track number - artist - title
17 - Animals - The House Of The Rising Sun
What I want to do is separate the track number artist and track title into three seperate cell using a function.
I know about RIGHT / LEFT / MID but is there a way to use the "-" in the above example to separate text strings of differing lengths?
Anyone got any ideas
Any answers much appreciated