Cell value in text string

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
 
K

Ken Wright

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"
 

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

Searching the formula (not the value) for a text string 1
ASK Field Formatting 1
Mapping integers to strings 6
Function or Sub to help with text string 5
EXCEL: find string in vector & return cell reference 1
search cell for specific text. 1
find and replace numeric strings in larger text strings 8
Counting unique instances of a text string 2

Top