Link to Multiple Cells Within One Cell Including Text
="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")&" . . .
--
Regards,
Tom Ogilvy
--
Regards,
Tom Ogilvy
"Rob" wrote:
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
|