Question
Line break in Excel via cfcontent
Hi, I'm trying to insert a line break within a cell in Excel
in a file being generated via cfcontent.
I've tried adding Chr(10), Chr(13) and Chr(13) & Chr(10) but none seem to do the trick. All appear to be ignored in the output.
I don't want to add a <br> tag because then Excel places in the information on the next row. I want the data to stay within the same cell.
Does anyone have any suggestions? Thanks!
I've tried adding Chr(10), Chr(13) and Chr(13) & Chr(10) but none seem to do the trick. All appear to be ignored in the output.
I don't want to add a <br> tag because then Excel places in the information on the next row. I want the data to stay within the same cell.
Does anyone have any suggestions? Thanks!
