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&""
or
=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.
Please enjoy!
No comments:
Post a Comment