Incorporating Numbers into a text string
 

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.

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

--
HTH

Bob Phillips

"Gary T" wrote in message
...
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.

Perfect.

Thanks Bob.




"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

"Gary T" wrote in message
...
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.