DavidObeid Wrote:
If I have a formula that concatenates text and numbers, for example,
=concatenate("The average of ",A1," and ",A2," is = ",(A1+A2)/2) and I
want the formula to display the "(A1+A2)/2" part as a fraction. The
values in A1 and A2 will be integers.
Can this be done in a non-VBA way?
I'm using Excel 2003.
Thanks in advance,
Dave.
="The Average of"&A1&" "&A2&" "&"is= "&(a1+a2)/2
should work
notice the spaces
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=564534