Export Multiple Fields of Data to One Excel Cell

[Kenneth Brody]

On 4/26/2012 6:36 PM, Scott Walker wrote:
>> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
[...]
>> A quick test with Excel 2007 shows that you can put a multi-line string
>> inside of quotes, and it imports it as a single cell from a CSV file.
>>
>> You should be able to simply put all of the description lines into a
>> single filePro field -- use CHR("10") to insert a line-break -- and export
>> it as usual.
 >
> Ken,
>
> Thanks for taking a shot but that just does not work for me.  I found that
> from the keyboard, Excel uses<Alt><Enter>  as it's soft return.  Maybe
> someone could tell me the codes for that I can try inserting them into the
> file.

"DDW".

Try the attached CSV file.

-- 
Kenneth Brody
-------------- next part --------------
A non-text attachment was scrubbed...
Name: foo.csv
Type: application/vnd.ms-excel
Size: 134 bytes
Desc: not available
Url : http://mailman.celestial.com/pipermail/filepro-list/attachments/20120426/4ddbfec9/attachment.xlb