If you recently installed 7zip software on your Windows 10 PC and now looking how to set 7zip as default windows 10 operating system, then you are in the right spot.
In this article, you are going to learn
If you are planning to install Blynk Server on any ubuntu server, then here is a step by step instruction on how to do that.
When I tried to install the Blynk server on Ubuntu cloud server, I didn’t get a clear guide on how to install blynk server, and I wasted a lot of time. So I thought to share this step by step instruction for users who are looking for such a guide.
Continue readingWant to know what the BSNL number you have? here is the guide on how to check your BSNL number easily.
Continue readingThere can be many reasons why you might want to split a large PDF file. Large files can be difficult to work with if you have to send them to someone via email or you need to work on a specific part of the file.
Often, parts of a document might be confidential, and other parties might not have the clearance to view or work on these parts. Splitting PDF files comes in handy in such cases. With a PDF editor, you can split a file into pages or multiple files as per your requirements.
If you are getting an error saying “Java was Started but Returned Exit Code=13” during Eclipse installation, then there is a fix for that. Even I faced this problem during eclipse installation on my windows operating system. After searching on google, I found that many of the users facing a similar issue with Eclipse. If you are one of them, then here is the solution for the error.
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 online case converter, then visit this case converter site to convert 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 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.