Concatenate excel keep number format from a forumula

[daleholden]

Hi Guys

In cell C16 £1298 and in Cell B16 i have £1179

In cell B17 i have a simple formula =C16-B16 which obviously provide an answer £119

But i want it to say £119 More Expensive and keep the number formatting

It is currently producing 119 More Expensive stripping the number format from the cell.

I have tried the =C16-B16 & TEXT(B17,"£#.##0") but i get an Value error

I have tried for over 1-hour trying different things but i am obviously missing something

Any ideas, please

 

[63falcondude]

How about making the formula something of the form ="£"&C16-B16&" more expensive"

 

[daleholden]

Doh thank you very much i just solved it another way as well must have had a brain fart before

=CONCATENATE("£",C16-B16," ","More Expensive")


Cheers falcon

 

[63falcondude]

Glad to help. CONCATENATE and the & symbol do the same thing.