Showing text from another cell (concatenation)

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!