DataGrid RenderControl to Excel

[Q. John Chen]

I used DataGrid RenderControl to Excel. It works great except one
thing:

I have a cell that contain new lines - <BR> it rendered to the Excel as
multiple-rows.

I replaced the <BR> with Char(10), that doesn't work either.

Any other tricks?

Thanks

John