Setting up a cell that contains text and a data reference?
"for the period ended "&Sheet2!A1
"Melanie" wrote:
I believe there is a way to set up a cell so that I can have text and a
formula in the same cell.
For example, I want to have a cell say "for the period ended (ref)". and
the reference would be to another cell on the worksheet.
any help?
|