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?
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.
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.
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 readingWant 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
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.
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 readingImagine 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.
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.
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.