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

The above formula should all be on one line.

--
Rick (MVP - Excel)


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