Another way is to use

="XYZ company will pay "&DOLLAR(Sheet2!A1)&" of your shipping costs"

"Courie" wrote:

Is there a way to insert a formula or reference a cell on another worksheet
in the middle of a text string.

For example if I wanted to say: XYZ company will pay $___________ of your
shipping costs... Where the blank was a reference from another sheet.
--
Thanks,

Courie