View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default 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?