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
-
Economics & Finance
MS Excel Articles
Page 83 of 119
How to Convert YYYY-MM-DD to Standard Date in Excel?
In Excel, we always try to show the dates in the format of dd-mm-yyyy, which is the standard format when we use the dates in Excel. However, when the date is given in a different format, some users may feel uneasy because they may have only used the standard format for a long time. Generally, in Excel, when we enter any format of date in the sheet, it will be directly converted to the standard format. If we try to convert any other format to standard format manually, then it can be a time-consuming and inaccurate process as we need ...
Read MoreHow to Convert HTML to Text in Cells in Excel?
Have you ever attempted to convert HTML text to plain text in Excel? If we try to complete this manually, then it can be a time-consuming and inaccurate process. The difference between the html text and normal text is that the html text has a header and footer, which are represented inside "< >". If those texts are removed from the HTML, they will be treated as plain text. In this article, we will learn how to convert HTML to text in Excel cells. In this tutorial, we will complete this task using the VBA application. Convert HTML to Text ...
Read MoreHow to Convert Hours to 8-Hour Work Days in Excel?
You could convert the number of hours to days in Excel many times. This process considers 24 hours as one day, but a normal work day will have eight hours. As a result, we can complete this task using the general method. We need to convert the hours to days based on eight hours to know how many days the employee worked in a month or year. In this tutorial, we'll look at how to use Excel to convert eight-hour work days into eight-hour work days. We can figure out how many days someone worked in a month or year. ...
Read MoreHow to convert inch to foot, cm or mm in Excel?
There are several length measurement criteria, including meter, mile, inch, foot, and foot. The most commonly used metric units are the metre and the mile. When there are any values mentioned in inches, we can change them into multiple metric units. In this tutorial, we will learn how to convert inches to feet, centimeters, and millimetres. A millimetre is one-tenth of a centimeter. We can convert inches to feet, cm, and mm directly using the formulas in Excel. Let us see how it is done. Converting inch to foot, cm or mm in Excel Here we will use the CONVERT ...
Read MoreHow to Convert Letter to Number or Vice Versa in Excel?
Sometimes in Excel, for encrypting the data, you have needed to convert letters to numbers based on their position in the alphabet series. For example, a = 1, b = 2, z = 26, and so on. Read this tutorial to learn how we can convert a letter to a number or a number to a letter based on their position in Excel. We can complete this process using the formulas supported in Excel. Mostly, this process is used for encryption and decryption of the data. Both encryption and decryption are used to provide security for data. Converting Letters to ...
Read MoreHow to Convert Letter Grade to Number in Excel?
In general, we try to grade the test using a letter such as A+, A, B, and many others, and the minimum GPA is always linked to the grade. You may want to display them alongside the letter grade at times. Read this tutorial to learn how you can convert letter grades to numbers in Excel. If we try to do this conversion in a manual way, then it can be time-consuming and sometimes inaccurate. So, we can use the VLOOKUP function to make our process faster and more accurate. Use VLOOKUP when you need to find things in a ...
Read MoreHow to Convert Kilograms to Stones and Pounds in Excel?
In general, we always try to measure weight in kilogrammes or grams, but there can be a situation where we need those values in stones or pounds. The metric system of weights and measures is rarely used. Converting the values that are in kilogrammes into stones and pounds can be a complex process if we are trying to do it manually, as those both belong to different categories. Read this tutorial to will how you can convert kilogrammes to stones and pounds in Excel. We can complete this process simply by using the formulas supported by Excel. Some of the ...
Read MoreHow to Convert Matrix Style Table to Three Columns in Excel
Sometimes in Excel, you may have needed to convert a matrix-style table to a column-style table. Any table with m rows and n columns is referred to as a matrix style table, and any table with m rows and three columns is referred to as a three column table in Excel. Read this tutorial to learn how you can convert a matrix-style table to a three-column table in Excel. We can complete this process with the help of a VBA application, as it can’t be completed directly in Excel. Converting a Matrix Style Table to Three Columns in Excel Here, ...
Read MoreHow to Convert Image URLs to Actual Images in Excel?
Sometimes in Excel, you could have faced a problem where you were provided with image URLs instead of images. If we want to get the images manually, then it can be a lengthy process. So, we need a faster process to complete it. This tutorial will help you understand how we can convert image URLs to actual images in Excel. We can complete this task with the help of a VBA application, as it can’t be completed directly in Excel. Convert Image URLs to Actual Images in Excel Here we will first create a VBA module and then run it ...
Read MoreHow to Convert Gallon to Liter/Ounce or Vice Versa in Excel?
Generally, we always try to measure a liquid in liters. It is the basic metric to measure liquids. Other metric units include ounces and gallon. When we measure in gallons, it is very important to change them into litres to make them more understandable to many users. In this tutorial, we will learn how to convert a gallon to litres or ounces in Excel. The litre can be the most accurate unit to measure volume. We use simple shortcuts to complete our process. Convert Gallon to Liter/Ounce or Vice Versa Using Formulas Here, we will first get any one of ...
Read More