| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate numerics and text
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 On Jun 23, 5:25*pm, Kris wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate numerics and text
Thanks Pete! That worked!!
"Pete_UK" wrote: 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 On Jun 23, 5:25 pm, Kris wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate numerics and text
You're welcome, Kris - thanks for feeding back.
Pete On Jun 23, 5:48*pm, Kris wrote: Thanks Pete! *That worked!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Numerics only | Excel Discussion (Misc queries) | |||
| Ignore text but not numerics on SUM() function | Excel Worksheet Functions | |||
| QUERRY ONLY RETURNING NUMERICS | Excel Discussion (Misc queries) | |||
| How to forecast non-numerics? | Excel Worksheet Functions | |||
| Formula with text and numerics | Excel Worksheet Functions | |||
Linear Mode
