Hi All,

I am using a old proprietary software that is very particular about formatting. Historically I have had to type out entries manually to create an invoice that is very time consuming so I am trying to concatenate the data points with a result of one cell with multiple lines to copy and paste into this software.

Currently when I copy multiple cells into this software it formats as cells with borders which is NOT an option for the final result.

Here is the is formula that i am i am using at the end of each line i hit alt enter to go to the next line:


=CONCATENATE(B5,C5,E5,F5,H5)
=CONCATENATE(B6,C6,E6,F6,H6)
=CONCATENATE(B7,C7,E7,F7,H7)

When i used only the top line of formula it works perfectly. When I add in line 2 and 3 the result I get is FALSE.

The end result I am looking for is one cell that I can copy and paste into the proprietary software in the following format. Here is an example of the result I am expecting.

85 widgets @ $1.00 = $85.00
75 widgets @ $2.00 = $150.00
50 widgets @ $4.00 = $200.00
Am i not understanding the "alt - enter" usage properly? What am I missing? Other suggestions?

Thanks Les