Importing into excel with a line break WITHIN the cell

[Scott Walker]

I've fiddled with this in the past and don't think I ever got it working correctly, but I'm about to try again so I thought I'd ask:

I have a database with (10) separate fields for the item description (Description Line 1, Description Line 2, Description Line 3, etc).  I want to export the data to a text file that will be imported into Excel.

I want all 10 description fields to end up in a single cell in excel with each line of description on it's own line but all in the same cell.

If I was typing it into Excel I would type the first line of description then <ALT><Enter> to start the next line of description in the SAME CELL.

What would I need to insert in the data stream coming from filePro to achieve the same result.

Regards,
Scott






Scott Walker
RAM Systems Corp.
scott.walker at ramsystemscorp.com<mailto:scott.walker at ramsystemscorp.com>
Cell:  (704) 619-3757







-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20231208/047a86e0/attachment.html>