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
Bookmarks