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 reading
There 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.