Not sure exactly what you mean but in any cell

="for the period ended "&A1

would concatenate whatever was in A1 to the end of the string.

Does that work?

Mike

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