Filling blanks up with values from other cels?

[Flemisch lion]

I have a problem.

I want to write a text into a cel. The text has several gaps whic
should be filled up whit the contents of other cels. I tried th
mathematic functions, but that doesn't work.

Let me explain by giving an example:

Text:

Excel is a programm developped by "contents of D3" and runs unde
"contents of G7", but there is also a version for "contents of K1".

Can somebody help me out

 

[Mike A]

On Wed, 7 Jul 2004 18:53:34 -0500, Flemisch lion

Text:

Excel is a programm developped by "contents of D3" and runs under
"contents of G7", but there is also a version for "contents of K1".

Can somebody help me out?

Enter your text as a formula, which allows you to concatenate the
contents of the required cells (using '&', not '+') in place:

="Excel is a program developed by " & D3 & " and runs under " & G7 &
", but there is also a version for " & K1 & "."

Have fun


Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers