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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top