Vista - Clipboard to Xcel CRLF problem

I have a problem when copying data from a datatable into clipboard
memory to be pasted into an Excel spreadsheet.

We create programs which work off a grid, and we provide a
"CopyToClipboard" facility off these tables.

The problem comes when we encounter CR, CRLF, and LF characters in the
comments field of the table.

We can remove these characters by taking the cell data and scanning/
replacing these characters, but we'd like to retain some kind of
linefeed within the cell so it can be pasted into a spreadsheet with
linefeeds.

The problem with CR/CRLF/LF is that it puts the rest of the comment
back into column A of a spreadsheet and throws any following cell data
out of alignment.

Can anyone suggest a way of retaining an excel LF within a cell in a
copyToClipboard manner.

Thanks in advance for any feedback