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.
|