I'm building up a product list that every time is different.
What I want is building up text in a sentence with reference to another cell.
That means; text [A1] text.
The outcome must be, for example; text information text.
When the cell is visible, show the entire result.
But when selected to edit cell should show; text [A1] text visible.