Cell value in text string

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Howdy guys,
I would like to know if it is possible to create a cell
reference in Excel within a text string. For example I
would like to be able to write "The profit of the prject
will be ...." and have a reference in the text to the cell
that contains the profit figure.

Is this possible as I cannot seem to find anything in help
that makes any sense to me.

Cheers,

Scott Burchfield
 
With the number 1 in cell A1, in any other cell

="This is "&A1&" way of doing it"

If it is a number you would like formatted, then use the TEXT function to do
that, eg

="This is "&TEXT(A1,"0.00")&" way of doing it"
 
Back
Top