Re: $$Excel-Macros$$ Need help on CONCATENATE and SUM function

A2:A4),0),"#,###") & ")" >> >> but for some reason, it doesn't "evaluate" the char(10) properly... >> >> interesting... >> >> Paul >> >> -- >> *From:* sharath sambrani >> &g

Re: $$Excel-Macros$$ Need help on CONCATENATE and SUM function

to use: ="FY09-Q4" & CHAR(10) & " (" & TEXT(ROUND(SUM(A2:A4),0),"#,###") & ")" but for some reason, it doesn't "evaluate" the char(10) properly... interesting... Paul ____________ From: sharath sambran

$$Excel-Macros$$ Need help on CONCATENATE and SUM function

Hi, i am trying to use sum function in concatenate function. i want to concatenate 'text' + 'sum of a range' + 'text' i want to use this in a column heading, say cell A1. cells A2, A3 and A4 has number values. in cell i want to display as: FY09-Q4 (4,464) FY10 should be displayed in the first