Today I wanted to be able to show the text which was stored in another cell, within a ‘string’ of text.
I wanted to have a name ‘John’ as plain text in cell C3. In cell A1, I wanted to be able to display ‘Hello <whatever is in cell C3>’.
My colleague Doug here at Best STL taught me how to do it: Concatenation.
This is the formula:
=”Hello “&C3
Simple as that.
Now I can update the name in cell C3 and all cells that reference will be changed instantly.
Thanks Doug!