Incorporating Numbers into a text string

[Gary T]

Hi,

I have a formula that produces a number in cell A1. This is currently
£5,085,030, but can range anywhere from £1 to £999 million.

How do I incorporate this into a cell that will read:

"Split of £5,085,030, based on Build Costs".

?


At the moment, I have

="Split of £"&round(A1,0)& ", based on Build Costs"

But this does not give me the comma separators betwwen the millions,
thousands and hundreds. how do I get them in?

Many Thanks,

Gary Thomson.

 

[Bob Phillips]

="Split of "&TEXT(A1,"£#,###,##0")&", based on Build Costs."

 

[Gary T]

Perfect.

Thanks Bob.

="Split of "&TEXT(A1,"£#,###,##0")&", based on Build Costs."