i have all of these media library entries (20K+) exported into excel... but just everything in one column arranged like
libraryentry#. artist - album - track# - tracktitle (tracktime)
18613. The Shins - Chutes Too Narrow - 01 - Kissing The Lipless (3:19)
is there a formula or series of formulas
that could break that up for me piece by piece?
--eg trim the libraryentry# starting w/ the period & going cutting
off the left
--then somehow trim everything right of the artist divider (space hyphen space), giving me a column w/ artist
--...& then similarly repeat until i get columns for each piece?