Question:
Is there an easy way to use a formula to concatenate two text cells and insert a new line between them?
Answer"
In C1 enter:
=A1&CHAR(10)&B1
Check Wrap text (for the formula cell) on the Alignment tab under Format|Cells.
(Source: http://www.mrexcel.com/forum/excel-questions/20775-concatenate-two-text-cells-new-line-inbetween.html)
Sunday, May 10, 2015
Sunday, May 3, 2015
Paste setting in Word 2010 and onwards
If you want to set "Keep Text Only" as your default, you can do the following:
- The default paste:
- Click the dropdown at the top and choose "More Commands":
- Click Advanced:
- Change the defaults (to Keep Text Only):
- Repeating the same paste defaults to text only:
How to fix Flash Player lag in Chrome
If you have some lags in Flash games and you are using Google Chrome, it’s possible that it’s caused by Chrome’s build-in Flash Player (Pepper Flash).
The word “Pepper” is there because they want to pepper life of flash game players … with lagging.
How to disable it? There is easy fix for that:
- Type (or copy paste) chrome://plugins Into Google Chrome address line and hit enter
- Click on “Details” in top right corner (it’s not seen on this screenshot)
- Deactivate Pepper Flash (You can tell if it’s Pepper Flash by checking it’s location)
- If you do not have any other version of Flash there (just Pepper), Install latest version of Flash Player: http://get.adobe.com/en/flashplayer
That’s it!
The lag in games should be fixed now!
(Source: http://blog.notsocasual.com/fix-flash-lag-chrome/)
Subscribe to:
Posts (Atom)