Help with CONCATENATE!

[Guest]

I use the Concatenate function to write some notes to a report I print in
excel. One of the notes reads " The total number of people to enter was
1234". Where the number 1234 is referenced from another cell.

How can I get the note to display the number with a comma separating the
thousands i.e. as 1,234. The referenced cell is formatted this way.

Thanks in advance to anyone who knows this!

 

[Guest]

One way, assuming the number is in A1:
=" The total number of people to enter was "&TEXT(A1,"#,##0")

 

[CLR]

Maybe this...........

="The total number of people to enter was
"&INT(A1/1000)&","&A1-INT(A1/1000)*1000

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Good one Max, mine only works up to 999,999............yours is much better!

Vaya con Dios,
Chuck, CABGx3

 

[Max]

Chuck, Thanks for compliment <g>

 

[Guest]

Thanks Max,
very neat solution - and so quick!
Nic

 

[Max]

You're welcome, Nic !