Concatenate and Format of result...

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

I have a simple formula that concatenate values from several cells:

=CONCATENATE(ROUND(D223,0), " ",ROUND(D224,0), " ",ROUND(D225,0), " on
",D227).

D223, D224 and D225 need 1000 comma separators in the result so that D223,
for example, would read 195,844 and not 195844 in the concatenated string.
As it is, these three cells do have the thousands separator format but the
format doesn't transfer to the concatenated result.

My thanks in advance for any suggestions here.

Cheers! Brad
 
=TEXT(ROUND(D223,0),"#,##0")&" "&TEXT(ROUND(D224,0),"#,##0")&"
"&TEXT(ROUND(D225,0),"#,##0")&" on "&D227

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You can use:

=concatenate(text(round(d233,0),"#,##0"), " ", ....

or just use the & operator

=text(round(d233,0),"#,##0") & " " &....
 
Back
Top