How to Join Cell Contents 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!