View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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?