OK, here's what I am trying to do...I am exporting an Outlook Task list to a
CSV file, which I am then opening in Excel and reformatting to make it all
pretty. I did some research here in this group earlier and found out how to
get rid of the "hard-returns" that show up as little boxes in the cells. The
problems arise because some of the cells have way too many characters and the
macro stops running when it hits them. If I go in and manually delete about
1/2 the contents of the cell (which is VERY long - it's the Notes from the
Outlook task list and can be many many lines of data) it will work. How do
I truncate the data in the cells, or what can I do to resolve this problem?
Any help would be appreciated!