How you can remove the first character in excel cells. This method works fine even if the first character is different character/text in each cell.
Example:
Before: 03Amazing Excel
After: Amazing Excel
In the above example, we removed first two character that is, 03 from the excel cell.
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
In the market for photo editing and social media, there is abundant software out there which are available to enhance how people look at themselves. These tools have been developed considering people in mind, what they need, and how they can provide the best software. Movavi Photo Editor is one such software that is basically conceived to bring minimal effort that an average user should spend to bring out beautiful pictures.
Continue readingFacebook 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.