Format Formula with Formatted Result

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

I was hoping to combine many cell results into one cell and control the appearance of that cell so that instead of one giant line of text, i can move to the next line within a cell when I choose.

So that:

"Unit 1 sold 45 units totaling $145.00, "Unit 12 sold 55 units totaling $175.00

Becomes:

Unit 1 sold 45 units totaling $145.00
Unit 2 sold 55 units totaling $175.00

I'm a bit confused. What is H5 referring to in your formula?

Originally Posted by AlKey

Or if you want with the equal sign

Formula:

=(B5&" "&C5&" "&E5&" "&DOLLAR(F5)&" "&H5&" = ")&DOLLAR(B5*F5)

v	B	C	D	E	F	G
4
5	85	widgets		@	1	85 widgets @ $1.00 = $85.00
6	75	widgets		@	2	75 widgets @ $2.00 = $150.00
7	50	widgets		@	4	50 widgets @ $4.00 = $200.00

I'm a bit confused. What is H5 referring to in your formula?

Originally Posted by Sambo kid

which person is on track? What you wrote in post 3 and I answered in post 5 or what AlKey is giving you about how to get the formula to show what you have in your second box in post 1?
we're sort of heading down two different tracks unless they are both your issues.
And, I would say that the H5 in his formula is simply referring to the H5 in your first post - he probably didn't show it in his snapshot.

Sorry. I had actually missed your reply. This is exactly what I needed.

Thanks to you both!