Hi everyone, i'm really stuck with this one....

I have recently been charged with exporting data from my companies ACT! database and putting into excel ready to go into our new CRM package.

I used an ACT! exporter that has left me a spreadsheet with data that I cant use yet.

The notes for a particular contact are not split up into different cells as they should be, rather they are all put into one cell with the dates in as such-

23/11/2000 quick brown fox jumped over the blah blah 24/11/2004 quick brown fox jumped over the blah blah 26/04/2005 quick brown fox jumped over the blah blah 27/04/2005 quick brown fox jumped over the blah blah 28/04/2005 quick brown fox jumped over the blah blah

basically every time there is a date i want excel to move the data before the next date into a new cell or at least a new line so i can copy/paste a new line.

Please can anyone help!!!!!!!!!!!

Thanks in advance!