Best way to insert value in a setenecne
Another way that doesn't require a helper cell, is to just format the cell as
Custom,
"Last week I ate "#" apples" and just type the number in the same
cell...........
Vaya con Dios,
Chuck, CABGx3
"dj479794" wrote:
Excel 2003.
If in one cell I have the following statement: "Last week I ate [ x ]
apples"
And I wanted to insert a number from another cell into [ x ]. How would I
do that?
I tried have the first part of the setence one one cell. The " [ x ] " in
the second cell and the rest of the sentence in the third. But because of
other things going on in the sheet I cannot get it to line up correctly. What
are my options?
|