Loading

Formating Problem -- Exporting to Excel

play26

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Adam Erstelle22y ago
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.smith22y ago
You could have a look at a couple of these samples..maybe they could help