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.
You need to read our Forum Rules and then post links to all the other Forums that you have posted this question on.
Thank you
You need something like, not the spaces in the text part to make sure the sentence is composed correctly.
="The component is " & A4 & " which means it's a " & B4
Don’t have an account yet? Register yourself now and be a part of our community!
