Pradeep Kumar has Published 1236 Articles

How to Convert Horizontal List to Vertical List in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 06-Mar-2023 14:11:45

594 Views

When we try to perform operations on a horizontal list in Excel, we may encounter some issues, and you may need to convert the same list to a vertical list to make it clearer. Attempting to complete this task manually can be time-consuming. So, we can make the process faster ... Read More

How to Convert Hex to Binary in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 06-Mar-2023 14:10:15

4K+ Views

There are typically four different types of numbers: decimal, binary, octal, and hexadecimal. The base values for binary, decimal, octal, and hex numbers are 2, 10, 8, and 16, respectively. Using Excel formulas, we can change a hex number into a binary number. The base values of the hexadecimal number, ... Read More

How to Convert Hex Numbers to Decimal Numbers in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 06-Mar-2023 14:08:29

6K+ Views

Numbers can be classified into four types: decimal, binary, octal, and hexadecimal. The base values of binary numbers, decimal numbers, octal numbers, and hex numbers are 2, 10, 8, and 16 respectively. We can convert a hex number to a decimal number using formulas in Excel. A hex number has ... Read More

How to convert inch to foot, cm or mm in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 24-Feb-2023 17:35:38

7K+ Views

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 ... Read More

How to Convert Letter to Number or Vice Versa in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 24-Feb-2023 17:34:33

4K+ Views

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 ... Read More

How to Convert Letter Grade to Number in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 24-Feb-2023 17:34:10

3K+ Views

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 ... Read More

How to Convert Kilograms to Stones and Pounds in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 24-Feb-2023 17:33:50

1K+ Views

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 ... Read More

How to Convert Lowercase to Proper or Sentence Case in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 24-Feb-2023 17:32:56

633 Views

Sometimes in Excel, you may have observed that the sentences in the sheet are not in proper format. If we can make our data look ugly, Manually resolving this issue can be a time-consuming and lengthy process. We can solve this process in a faster and more accurate way using ... Read More

How to Convert Matrix Style Table to Three Columns in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 24-Feb-2023 17:31:59

951 Views

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 ... Read More

How to Convert Image URLs to Actual Images in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 24-Feb-2023 17:28:52

5K+ Views

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 ... Read More

Advertisements