Joining Text and Formatted Number

[BillCPA]

I am using the formula CONCAT("Total Cost ",ROUND(SUM(A2:A50),0)) in a cell to get the result Total Cost 123456 (where SUM(A2:A50) is equal to 123456).  Is there some way to format the number to 123,456?

[#2 · Accepted solution]

@BillCPA Yes, use CONCAT("Total Cost ",Text(ROUND(SUM(A2:A50),0),"#,000"))

[#3]

@DexterG_III  - thank you - looks good.

[#4]

@BillCPAMy pleasure.  Would you kindly mark my response as the solution if it works? 

Regards,

Dexter 

[#5]

This is my first time here - did I mark correctly?

[#6]

@BillCPA yes, perfect & thank you.