split records

[zutis]

Hi

I have more than 10000 records in one column ,
example:
.......
|16 Volt - Skin [1994]|
|16 Volt - Supercoolnothing [1998]|
|20 Dead Flower Children - Candy, Toy, Guns & Television [1997]|
|3 Doors Down - Away From The Sun [2002]|
|3 Doors Down - Better Life [2000]|
|A - Hi-Fi Serious [2002]|
|A.T.C. - Planet Pop [2001]|
|AC DC - Back In Black [1980]|
|AC DC - Ballbreaker [1995]|
|AC DC - Flick Of The Switch [1983]|
|AC DC - Fly On The Wall [1985]|
..........

and i need to split this records in 3 columns:
Artist | Album | Year

maybe someone can help me ...

 

[Arvi Laanemets]

Hi

Hi

Use Data.TextToColumns.
At start with ' - ' as delimiter, then for newly-created 2nd column with
' ]' as delimiter. And at last use ReplaceAll to remove all ']'s