How to Remove Last Character in Excel
Sometimes we need to remove extra characters which come in excel cells. If those additional characters are all of the same type or same characters, then we can easily remove those by using Find and Replace method.
But what if, if all of those are characters are different, and they are the ‘last character’ in excel cells?
Change Case using UPPER, LOWER and PROPER Function
In excel there are three different cases available as follows.
=PROPER() capitalizes the first letter of each word (like Title Case)
= UPPER() – forces all letters to be UPPERCASE
= LOWER() – forces all letters to be lower case
Tip: If you are looking for an online case converter, then visit this case converter site to convert the case.
Replace Space Between Two Words with Underscore
If you have a column with name and surname with space between them and now you want to remove this space and add an underscore (_) between these two words, then Find and Replace is useful.
For example, In B column we have Amazing Excel, which we want to replace with Amazing_Excel and same for all in selected cells.
How to View Youtube Thumbnail
You know how many times it would have happened with you that you are watching a video on YouTube, and all of a sudden, you come across a thumbnail from the video that you have just seen across the feed, and you wanted to download that.
However, you also understand that it is tough to download that instantly. So you try out various ways like taking screenshots, copying the URL of the YouTube video, and pasting in the browser, hoping that you will get an option to download.
Continue readingHow to Transfer Half Downloaded Torrent files to Another PC?
Want to move half downloaded torrent files to another computer? and need to continue where the download is left off? This is really easy to achieve. But many of the users still not aware of this method. In this post, I will show you how you can move partially downloaded torrent file to another computer and continue where it is left off.
Continue reading
How to View Full Size Image of Users Who Activated Facebook Profile Picture Guard
Facebook introduced profile picture guard to protect users profile images. If you are not aware of that, then it’s a kind of features to prevent misuse of facebook users profile images. If users activated this option on their Facebook profile image, then other people can’t tap Share, Send in the message, Share externally, Zoom/View full size of the image or Download from your current profile picture on Facebook.
A small blue shield icon will appear below the users profile if they activated this facebook profile image guard feature. You can read more about this feature here.
Many of the users thought that this feature would prevent other users from downloading their profile images from facebook. But the fact is NO. It won’t stop others from downloading your profile picture. With a small little trick, any users can easily download facebook profile guarded image from facebook easily.
How to Get Credit Card in India Easily
Thinking of getting a credit card for yourself? Don’t know how to get it? That’s Ok. Even I was in the same position before. In this post, I will explain how you can easily get credit cards in Indian without working in any company or without having any salary slips.
Continue reading[FIX] DPC Watchdog Violation in Windows 10 & Windows 8
Imagine that you are working on your windows laptop or a windows PC and all of a sudden for no reason, your screen turns blue with a sad smiley all over in the middle. If you also notice, then there will be a message displayed right below it, saying “Your PC ran into a problem which it cannot handle, and now needs to restart”. So basically, everyone in your position freaks out including me, which is quite common since you don’t know the exact reason why it happened. So first of all, let me assure you that this is not a primary concern and many other users also face these issues frequently.
Error 651 with PPPoE connections in Windows [FIX]
When you try to share your broadband connection in windows OS you will see Error 651. The complete error message will look like
Connecting through WAN Miniport (PPPOE)…
Error 651: The modem (or other connecting device) has reported an error.
If you’re getting this message then here is the solution to fix this error.
The Complete Guide to Google Chrome Handlers
If you are using Google Chrome as your default browser, then you will notice that–clicking on any mailto: links will open either in Gmail.com website or it does nothing. The behavior what it needs to be done when clicking on those special links is termed as protocols, and the programs they use are called handlers.