Link to Multiple Cells Within One Cell Including Text
 

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

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

Link to Multiple Cells Within One Cell Including Text
 

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

Rob


"Tom Ogilvy" wrote:

="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