pls. help!!!

  • 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
 
use the formula:
= "The answer is " & B4

If you need the double quotes as part of the string, then you'd have to
enter them twice:

= "The answer is """ & B4 & """"
(so three double quotes after 'is' and four after the last ampersand. The
outer are telling Excel you want a string, the two inner are to tell it's a
double quote you need as opposed to the end of the string)

Bas Hartkamp
 
Back
Top