Link to Multiple Cells Within One Cell Including Text

[Guest]

Does anyone know if is possible to link to multiple cells within a single cell?

Example:
The total shippable as of {D5} is {D6} with a total on-order of {D7}. The
percent of total shippable to total on order is {D8}. Another {D9} ({D10}
total) in new orders is needed to reach the {D11} forecast. Please move up
future orders and work with credit to release shippable holds as soon as
possible. A copy of the shippable hold report is also attached.

Thank you,

Rob

 

[Guest]

="The total shippable as of "&D5&" is "&D6&" with a total on-order of &"D7"&.
The
percent of total shippable to total on order is " & ... and so forth

if you want formatting - say D5 contains a date

="The total shippable as of "&Text(D5,"mm/dd/yyyy")&" is
"&Text(D6,"#,##0")&" . . .

 

[Guest]

That is awesome and it worked perfectly. Thank you so much for your help.