I want to change the word in text, not the cell. The thing with the cell you explained to me, and I managed to do it. However, the question was, is it possible to do it with text as well.



So, at the beginning, there is a text in the cell:

You must provide steel beam.

If I choose option B from the drop-down menu, I will have the text changed to:

You must provide wooden beam.

If I choose option A again, I will have the same sentence from beginning (steel). Only the word steel and wooden changes. Everything else stays the same.

The principle is the same, I need to change something according to the selection. However, here I need to change the word in the text instead of cell.