CSV files, ASCII characters, and Outlook Tasks Lists...oh my!

[paularo]

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!

 

[paularo]

Steve,

No, the ultimate plan is to e-mail it to someone else as an update on
projects in the works. I have a great macro that makes it all pretty, but it
just keeps hanging up on the really long data strings in some of the "notes"
cells. I just want to shorten them to a hundred characters or so, and
truncate the rest.

Paula