How do I use a linking formula in cell with many words?

[Guest]

I have a form that has a bunch of text in it. Most of the cells in this form
have wrapped text. We would like to be able to fill in words in part of the
text, based on information entered in another cell in the same worksheet, or
workbook. Is it possible to do that if the cell has a paragraph in it? Can
we, like in Word, insert a type of field, in the middle of that paragraph?

Any suggestions, please let me know.

Thank You!

 

[Guest]

Hopefully this is what you are looking for:

Example:

Cell A1 is your field that is changeable (say a persons name)
Cell B1 is your text

so,

B1 = "Dear " & A1

would produce Dear Mr ABC if cell A1 contained the value "Mr ABC".

This also works with:

B1 = "Congratulations " & A1 & " - you have won a prize!"

this would give "Congratulations Mr ABC - you have won a prize!"

(substitute your cells and text - hopefully you get the idea!

 

[Guest]

Thank you so much! Works like a charm.

Hopefully this is what you are looking for:

Example:

Cell A1 is your field that is changeable (say a persons name)
Cell B1 is your text

so,

B1 = "Dear " & A1

would produce Dear Mr ABC if cell A1 contained the value "Mr ABC".

This also works with:

B1 = "Congratulations " & A1 & " - you have won a prize!"

this would give "Congratulations Mr ABC - you have won a prize!"

(substitute your cells and text - hopefully you get the idea!