Building up sentence variable within cells

[Reiniervdijk]

Hi


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.

26528

[paulked]

formula in E4 =CONCATENATE("The component is a ",A4," which mean's it's ",B4,".")

[Reiniervdijk]

Thank you paulked

[Reiniervdijk]

The Cross-posting links are here;


https://www.ozgrid.com/forum/index.php?thread/1227416-building-up-sentence-variable-within-cells/&postID=1234621#post1234621


https://www.mrexcel.com/board/threads/building-up-sentence-variable-within-cells.1132666/#post-5478019

[paulked]

You're welcome :thumb