Hello,

I was wondering if it is possible to use <BR> in a Excel cell formula. I am using Ebay File Exchange to upload large data. The issue is File Exchange does not allow for line break or carriage return in my description field. What I have currently is,

cell B2 contains (A102)
cell C2 contains (This is a part item)

="Part Number: "&B2&C2

Which outputs -> Part Number: A102 This is a part item.

I need it to output:

Part Number: A102

This is a part item.


Thanks Jr