Excel Import - Layout Question

[gerard]

Hi

I'm importing data from an excel file, and one of the columns (the full description) has five different sentences in it.

I'd like these to appear as five different lines on the final product page, but I'm not sure how to go about formatting the excel sheet to do this. I've tried <br> and that doesn't work.

Any ideas?

TIA

[gerard]

Ah, just found it in the help section:

This is the more detailed description of the product. The text normally wraps at the end of the line. To force a new line, insert '\n' (without the quotes) at the appropriate point in the text. Alternatively, enclose the field in double-quotes and break the field using the keyboard <Enter> key.