Hi folks, I thought I understood the text to columns feature but I guess I don't. I have attached a spreadsheet with a column A that contains an album name and the date it was released. I want to seperate this into 2 columns, column A being the album name and column B the album release date. I thiught I could just select the cells and click on text to columns, and then use "-" as the delimiter but this isn't working for me. Any advice here? Many thanks

Attached Files

for excel forum.xlsx (9.4 KB, 5 views)