concatenate numerics and text

[Kris]

i need to concatenate numbers and text but don't want the numbers to lose
formatting. For example this is what I want a single cell to say:
The minimum = 22,309.09; the maximum = 36,999.30; the standard deviation =
5,559.59
Where the numbers and text will all be concantenated separately b/c the min,
max, and stdev are coming from separate columns. I can get these all
together using concatenate but then the numbers lose their commas. Does
anyone have advice?

 

[Pete_UK]

Try this:

="The minimum = "&TEXT(A1,"#,000.00")&"; the maximum = "&TEXT(B1,"#,
000.00")&"; the standard deviation = "&TEXT(C1,"#,000.00")

where I have assumed cells A1, B1 and C1 hold your values - adjust to
suit.

Hope this helps.

Pete

 

[Kris]

Thanks Pete! That worked!!

Try this:

="The minimum = "&TEXT(A1,"#,000.00")&"; the maximum = "&TEXT(B1,"#,
000.00")&"; the standard deviation = "&TEXT(C1,"#,000.00")

where I have assumed cells A1, B1 and C1 hold your values - adjust to
suit.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Kris - thanks for feeding back.

Pete