Categories
Excel Training

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.

Concatenation example in Excel
Concatenation example in Excel

Now I can update the name in cell C3 and all cells that reference will be changed instantly.

Thanks Doug!

 

By Richard Bailey

I love what I do; I get to work with an outstanding team to help hundreds of people with their challenges. I’ve learnt a lot from the teams I’ve worked with, no matter the size or industry we all have challenges to overcome, difficult customers, creating a budget or keeping a project on track.