Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to create a domain name finder app in ReactJs?
An online application that enables users to look for accessible domain names using keywords or phrases can be called a domain name finder. It is a helpful tool for companies and individuals wishing to register a new domain name for their websites. Users of this software can look up domain names and display the search results along with other details like cost and availability. To build a ReactJs domain name search app, one must first plan the app's structure and decide which features to include. After configuring the development environment, a search field can be added so that users can ...
Read MoreHow to validate Passport Number is ReactJS?
Passport number is very sensitive data, and it always requires to validate. For example, you are taking the user’s data for their identification, and you can use the passport number to validate the user’s identity. Sometimes, the user may enter the wrong passport number. However, you must need to use the database to check whether the passport number matches the user’s real passport number. Still, when a user enters the passport number, you should ensure that the user has entered the correct format. This tutorial will teach us various approaches to validating passport numbers in ReactJS. Use the Validator ...
Read MoreHow to Convert True False to Checkbox in Excel?
Sometimes when we have True or False values in Excel, you would have needed to change them to checkboxes for better and accurate analysis. We can solve this task using the VBA application, as it cannot be completed directly in Excel. Read this tutorial to learn how you can convert True to False values to checkboxes in Excel. In other words, the checkbox will be checked if the value is True, and the box will be unchecked if the value is False. Converting True False to Checkbox in Excel Here, we will first create a VBA module and then run ...
Read MoreHow to Convert Traditional Chinese to Simplified Chinese or Vice Versa in Excel?
Have you ever wondered if Excel has an inbuilt translate function that can assist us in converting between languages without the use of any external applications, such as uploading the content to the internet and performing the operations? The translator can be used to convert between the languages. Sometimes in Excel, you want to convert traditional Chinese to simplified Chinese to reach more people. As traditional Chinese can only be understood by a few Chinese people, the simplified version is easier. The most obvious difference between traditional Chinese and simplified Chinese is the way the characters look. Traditional characters are ...
Read MoreHow to Convert Time to Integer Hours or Minutes in Excel?
An "Integer hour" is a time that is represented as a number. Sometimes in Excel, you may have needed to convert the given time to integer values. If we try to do this task manually, then it can be a time-consuming process, however we can solve this task using the formulas supported in Excel. The difference between a decimal and an integer is that the latter will not have any point values. Read this tutorial to learn how you can convert time to integer hours or minutes in Excel. We must use the INT function because we must return the ...
Read MoreHow to Convert Time Format from 12 Hour to 24 Hour and Vice Versa in Excel?
Generally, in Excel, converting time can be one of the most common tasks. If we try to do it manually, then it can be a very time-consuming and complex process. A 12-hour clock has two sets, namely AM and PM, whereas the 24-hour clock has only one set. As almost all the clocks show us the time in 12-hour format, it can be an important process to convert the time into 24-hour time because 24-hour time can be used as a standard method to use the time without mentioning am or pm. Read this tutorial to learn how you can ...
Read MoreHow to Convert Time Difference between Two Times to Number (Hours/Minutes/Seconds) in Excel?
In general, we will need to work with times more frequently in Excel. If we try to perform the difference between two different times manually, then it can be a complex and time-consuming process. When we calculate the time difference between two different times directly using the general formula, the value will be returned in hours, minutes, and seconds. Sometimes you need the difference only in hours, minutes, or seconds. We can use the process discussed in this tutorial to complete this task. Read this tutorial to learn how you can convert the time difference between two times to only ...
Read MoreHow to Convert the Phone Number Format to Digits in Excel?
Generally, when we need to collect mobile phone numbers on an excel sheet, the values are stored in a special format to differentiate them from normal digits. The special format is a "-" separator used after the third and sixth digits in the ten-digit phone number. However, you may need to convert those phone numbers to standard digit format on occasion. If we try to do that manually, then it can be a complex and time-consuming task. Using the formula, we can complete the task more quickly and easily. Read this tutorial to learn how you can convert phone number ...
Read MoreHow to Convert Text Strings to Formulas in Excel?
Assume you've saved your formulas as strings in an Excel sheet to be calculated later; if we want to use them, we can because they're stored as strings rather than formulas. It can be very time consuming to manually convert them into formulas. So, we can use a user-defined function to complete our task in a faster way. Read this tutorial to learn how you can convert text strings to formulas in Excel. We can create the user-defined function using the VBA application. Because this task cannot be completed directly in Excel, we must use a combination of VBA application ...
Read MoreHow to Convert Text String to Proper Case with Exceptions in Excel?
Have you ever wondered if there is a way in Excel to automatically correct the case of strings in a sentence? It is possible to make it happen in Excel. This tutorial will help you understand how you can convert text strings to proper cases with exceptions in Excel. We can complete this task using the VBA application, as it can’t be completed directly in Excel. When the letters of the words are in the correct case according to grammar, they are called "proper case." Converting Text String to Proper Case with Exceptions in Excel Here, we will first create ...
Read More