Spreadsheet Tips

How to Join Cell Contents with "&"

March 22, 2018
How to Join Excel Cells with &

Sometimes, you'll have data that's split into multiple columns that you need to join up. There's a variety of ways to do this in Excel, but my favorite way is the quickest: just reference the cells, and add an & between them to link them up.

Bonus tip: you can use &" "& to add a space between two cells that you're joining up. Try it out!