Incorporating Numbers into a text string

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

--
HTH

Bob Phillips

"Gary T" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>