Mixing both text and a formula/function in the same cell possible?

[dgurjala]

Hello,

I have a single cell within which I would like to display the content
of other cells in the worksheet.

Specifically, throughout the worksheet I have columns for patient name
postoperative day, and procedure performed.

It turns out that it would be very convenient to display within th
patient name cell the postop day and procedure information. so in
single cell i would like to have the patient name and right next to i
in tiny font information from other cells.

so this would probably involve mixing both text (patient name) an
functions/formulas (eg, concatenate reporting values from other cells
within the same cell.

Any idea how I can do this?

thanks very much

 

[Frank Kabel]

Hi
you can't have both in a cell. A manual entered text and a
formula. Why not use separate cells next to each other?

In addition: A fiormula can't change the font of its
returned value!

 

[JBoulton]

Hi.

If cell a1 has a name and cell b1 has a date, you can put this formul
in c1. I think this will handle it for you.

=A1&" "&TEXT(B1,"mmm dd, yyyy")

Good luck