How do i display contents of one cell in another?

  • Thread starter Thread starter Dev Gurjala
  • Start date Start date
D

Dev Gurjala

hey all, if anyone could help me with this it would be
great. Within a single cell, I would like to display the
contents of other cells on the worksheet. specifically,
i have a cell with a patient name in it. I have another
cell with postoperative day and another cell with
procedure done. In the Patient Name cell, I would like
to have the post op day and procedure show in up in very
small font right next to the name. Is there a way to do
this? thanks!
 
You can reference the other cell like;

="Bob Smith "&B1&" "&C1

if date is in B1 and procedure in C1. I don't know if there's a way to make
that part of the text in any smaller font than the rest.
 
Back
Top