Try this (all on one line):

="The total cars sold this month was "&A35
&" which is "&D4&" % of our yearly total"

Depending on the formats of the referenced cells, we might have to tweak it
a bit. See how that works.


--
Biff
Microsoft Excel MVP


"Ozinus" wrote in message
...
Eg: The total cars sold this month was (Cell A35) which is (Cell D4) % of
our
yearly total