Formating Problem -- Exporting to Excel

Question

I'm exporting data to Excel and I want to specify the number of characters on one line and if the number characters exceed that number I want to continue on a new line within the same cell. I've tried to insert a new line character; however that didn't solve the problem. Any help is greatly appreciated === Muk

Adam Erstelle · Answer

In order to get the proper character what you may have to end up doing is importing an excel file that has a cell with the new line character. You will have to retrieve the ASCII code of that character. Once you have that character code you can insert the character (use function to get character based on ASCII code) at the point that you need. This isn't the solution to your problem but hopefully it will help you solve it.

tyrone.smith · Answer

You could have a look at a couple of these samples..maybe they could help