Joining Text and Formatted Number

New Contributor

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?

5 Replies
best response confirmed by BillCPA (New Contributor)

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

@DexterG_III  - thank you - looks good.

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




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

@BillCPA yes, perfect & thank you.