Forum Discussion
Haytham Amairah
Feb 05, 2017Silver Contributor
How to add separator (comma) inside a formula?
How to separate the value of SUM by comma in this case?
- Feb 06, 2017
Haytham, format the SUM as well, like ="Total: " & TEXT(SUM(D3:D12),"#,##0_ ;-#,##0 "). If I understood your question correctly...
azahaib
Aug 10, 2020Copper Contributor
=LARGE(N6:N15,1)&" on first "&LARGE(N6:N15,2)&" on second "&LARGE(N6:N15,3)&" on third "
Hi can we add separator commas in this formulae.?
THanks