Using a formula in a sentence
Here's a shot at it...
In F1 enter this partial sentence:
The number in cell J1 is (enter a space after the word "is")
In J1 enter 100
In A1 enter =F1&J1
Another shot at it is to do F1 and J1 as above except do not enter the space
after "is". Then use this formula in A1
=F1&" "&J1
HTH
Regards,
Howard
"krissy" wrote in message
...
Is this possible? If so, how do I do it?
|