Sometimes it is useful (or necessary) to extract part of a cell into another cell in Excel. For example, you may have a cell that contains a combination of text and numbers, or a cell that contains two numbers separated by a delimiter such as a comma.
Showing posts with label Tricks. Show all posts
Showing posts with label Tricks. Show all posts
8 Whatsapp Trick That Every User Should Know!
For most of us, WhatsApp has become the default messenger, because everyone's on it, and it's on nearly every platform. WhatsApp has over a billion downloads on Google Play alone, the only other messenger to boast that is Facebook Messenger.
For those who have to deal with the app on a daily basis, we've listed up some interesting tricks and tweaks that will improve your user-experience.
For those who have to deal with the app on a daily basis, we've listed up some interesting tricks and tweaks that will improve your user-experience.
How to create an invisible folder on Desktop
1. Create a New folder on Desktop.
2. Change the Icon of the folder by right clicking the folder. Click Properties -> Customise -> Change Icon. Scroll until you find a Blank icon. Click Ok.
3. At this point you are left with Something Like this.
4. The Last step is to remove the folders label. Go to start and search "Character Map" without quotes. Then select the blank character and copy it as shown.
5. Now Simply right click the folder and click Rename. Paste the character by pressing Ctrl + V and viola! You have your own invisible folder.
Note:- If you forget the location, simply click anywhere on your Desktop and drag.
Subscribe to:
Posts (Atom)
Popular Posts
-
Merging of two Excel files using VLOOKUP function comes very handy if we're manually matching two Excel files, it is very time consumi...
-
Taking the time to learn some Excel tips and tricks will likely help you boost your productivity and streamline your spreadsheets. We pr...
-
This article assumes you are using Excel on a Windows PC. If you are using a Mac, these shortcuts will change slightly. All the Keyb...
-
The copyright ©, trademark ™, and registered trademark ®, symbols can be inserted quickly in Office applications using the Autocorrect feat...
-
The VLOOKUP is one of the most used formulas in Excel across all sorts of different industries. The “V” in VLOOKUP stands for vertical. It ...