How to Remove First Character in Excel
What you will Learn:
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.
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 online case converter, then visit this case converter site to convert 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 is very difficult to download that instantly. You try out various ways like taking screenshot, copying URL of the YouTube video and pasting in the browser hoping that you will get an option to download.
How to Disable Auto Opening After Completing Download on Google Chrome Browser
Downloaded image auto opening? That’s what I noticed recently. It was not happening earlier, but recently when I started downloading any images on Google Chrome browser that image started auto opening on windows image viewer application (Photos). If you are also facing the same issue, then here is the solution.
Initially, I thought it was due to some windows update because few days before my PC upgraded my operating system, so I thought during the recent update this changes came like that I thought. But after searching for a solution, I noticed it’s not due to Windows OS, but it’s due to chrome browser.
How 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 Disable Web Push Notification on Firefox
I’m tired of those sites keep asking “Never miss updates” kind of web push notification on the browser. These days almost whatever the site I visit, they keep showing such alreats on the browser. I’m fed up seeing those and tired of clicking “NO” to such notification request. Even our Adblock extension cannot help in blocking such alerts. I was eagerly waiting for some good solution to avoid those web push notification completely.