It's a Excel Tech Tip kind of week!
I made this for one of my favorite humans. She uses these quite a bit, but sometimes the memory of them hides on her.
The first one, Concatenate, is delightful. There are a number of ways to do this task, so I listed our personal favorites. It's like mail merge for Excel! It will take the text in multiple cells and display them in a single cell. The two examples will display the same way.
=A1&" "&B1&" "&C1&""
=CONCATENATE(A1, B1, C1)
You can even get a little fancy and add punctuation or words in between each cell:
=A1&" & "&"B2 would display as Bob & Steve (if A1=Bob and B2=Steve)
Similarly, you can use Concatenate:
=CONCATENATE(A1," & ",B2) would also show up at Bob & Steve
For the second part of the poster - Paste Value. There are a lot of "Paste special" options - I personally use Paste Value more often in what I'm working on. It is especially helpful if you want to paste the contents of a cell into another part of a spreadsheet, but want the hard coded number, not a link to the live data that might change tomorrow. Paste Value takes the formula away and just leaves you with the number, no frills, no database connections.