View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kris kris is offline
external usenet poster
 
Posts: 128
Default concatenate numerics and text

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?