Inserting a formula into a text string
="XYZ company will pay $"&Sheet6!A1&" of your shipping costs"
--
David Biddulph
"Courie" wrote in message
...
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
|