We begin with a small table that contains names (text) in column A and amounts (numbers) in column B.
Our goal is to have the name and amount for each row of the table displayed in a single cell (column C).
This needs to be done dynamically so that a change in either the name or amount will trigger an update in the combined version in column C.
This can be accomplished with a CONCATENATE function.
CONCATENATE is a big, fancy word for “join things together”.
Excel has a dedicated CONCATENATE function, but most users will opt to use the simplified version of CONCATENATE… the ampersand (&) symbol.
For example, we begin in cell C2 and write the following formula:
=A2 & B2
Pressing ENTER to commit the formula results in the following:
This is the purest form of concatenation; everything is just smashed together. It works, but it’s not visually appealing.
Concatenation is not limited to existing content. We can inject new content into the formula to enhance the results. In our case, we’ll inject a ‘space’ to provide visual padding between the name and the amount.
The ‘space’ needs to be surrounded by double-quotes. Any injected text needs to be surrounded by double-quotes.
=A2 & “ ” & B2
The updated formula’s result is a bit easier to read.
Think of the ampersand character as the word “and”. “Display the name in cell A2 and a space and the number in cell B2.”
You can place anything you wish between the two double-quotes, like a dash, slash, or any other character.
Returning to using a ‘space’, we fill the formula down to the remaining rows to reveal the following: