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!


--
DJS1234
------------------------------------------------------------------------
DJS1234's Profile: http://www.excelforum.com/member.php...o&userid=28060
View this thread: http://www.excelforum.com/showthread...hreadid=475762