I have a formula that generates a string separated by newline characters (added using the ChrW(10) and ChrW(13) methods). This works great when viewing the report in crystal format, but when I export to excel data-only I want these newlines to be each in a separate row. Instead, they simply show up as a box in excel (the unprintable character symbol). Is the desired effect possible?
I should mention that I don't care how the solution makes the crystal report look through crystal, the excel report is the only one that will ever be used.