so that worked - apart from 1 row
Iron Maiden 2013-06-05 Paris
which does not have the - between the name and date
see attached
once done
I would then copy the range B1 to D??
copy
paste special
Value
so then the formulas are replaced and you have text to do what you like with
and can delete column A with no effect
Bookmarks