<div>
<div class="content wysiwyg-content">
Hi Experts excel 2007<br />
<br />
I am trying to concatenate the following whlist also using the text function cannot see the error here...<br />
<br />
=concatenate (text (sum (a1, a2, a3),&quot;#,##&quot;)&amp;&quot; | &quot;&amp;text (sum (b2/b5)*100),&quot;0%&quot;)
</div>
</div>


Hi Experts excel 2007

I am trying to concatenate the following whlist also using the text function cannot see the error here...

=concatenate (text (sum (a1, a2, a3),"#,##")&" | "&text (sum (b2/b5)*100),"0%")

concatenate and text formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.