Skip to main content
Inspiring
March 24, 2009
Question

Line break in Excel via cfcontent

  • March 24, 2009
  • 1 reply
  • 726 views
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!
    This topic has been closed for replies.

    1 reply

    kiyomiAuthor
    Inspiring
    July 2, 2010

    FYI, in case anyone else is having this issue, I solved it by using a <BR> tag and adding in the stylesheet:

    br {mso-data-placement:same-cell;}