File Transfer - Create cell with line breaks

Print Page | Close Window

Create cell with line breaks

Printed From: Rocket Software
Category: AccuTerm Knowledge Base (read only)
Forum Name: File Transfer
Forum Description: Help with uploading & downloading database and document files
URL: https://forum.asent.com/forum_posts.asp?TID=2570
Printed Date: March 26 2026 at 8:51pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: Create cell with line breaks

Posted By: troyd1000
Subject: Create cell with line breaks
Date Posted: April 14 2016 at 6:27am

I am trying to figure out how to download multivalued data (comments) into excel so that the that all the mutlivalued data goes into 1 cell with line breaks. I tried actually putting char(13) in the data as that is what the excel cell looks like if you save it as a csv, but cannot get it to work. I have resorted to putting in a delimiter, selecting the column and swapping the delimiter with ctrl + shift + J which seems to work. Is there a way to do this so the client does not need to do this replace?

-------------
Troy