Display contents of cell as variable?

  • Thread starter Thread starter Lovebaby
  • Start date Start date
L

Lovebaby

How can I display the contents of a cell in another as part of a text
string.

Such as... "The answer is "B4""

where B4 is the contents of cell B4?

Thanks
 
Try:
="The answer is "&B4

Don't forget the space after the is/before end quote or it will look line
The answer is72 versus what you want.

Brian
 
Back
Top