How to Convert Units in Excel (3 Handy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Conversion of units is the process of modifying units of measurement for the same quantity, usually by multiplying factors of conversion. This means that the conversion process depends upon the situation and its intended purpose. In this article, we’ll discuss 3 methods to convert units in Excel.

Unit conversion in Excel is a fairly common and easy procedure hence there are a handful of different methods. So let’s go through them one at a time.


1. Using CONVERT Function to Convert Units in Excel

Unit conversion is made easy by Excel’s built-in CONVERT function which takes in 3 necessary arguments and offers a vast array of unit conversions. For example, you can convert the units from Fahrenheit to Celsius, meters to feet, pounds to kilograms, etc. In the first method, we’ll show you the use of the function in the case of a single cell.


1.1. Converting Units in a Single Cell

Now, let’s begin by converting the Temperature from degree Celsius to degree Fahrenheit for a single cell as shown in the table below. Here, the Temperature of Alabama state is given in Celsius. And we want to convert it to Fahrenheit in the D5 cell.

Using CONVERT Function in Single Cell

Step 01: Choose a Cell to Enter the Command

  • To start, select the D5 cell.

Using CONVERT Function How to Convert Units in Excel

  • Then, type the following:

CONVERT(C5, “C”, “F”)

Here, C5 refers to Temperature (Celsius), “C” and “F” indicate the short form of Celsius (from_unit argument and Fahrenheit (to_unit argument) respectively. In this formula, we used the CONVERT function, the most popular way to convert units in Excel.

Using CONVERT Function How to Convert Units in Excel

Step 02: Get the Results

  • Now, click ENTER and the temperature is converted to Fahrenheit.

Using CONVERT Function in Single Cell


1.2. Converting Units in Multiple Cells

In the previous method, we showed the way of converting units in the case of a single cell. What if you have multiple cells to convert the units? Luckily, you can use the same formula except you have to use the Fill Handle tool.

Using CONVERT Function in Multiple Cells

Step 01: Enter the Command

  • Firstly, select the D5 cell.
  • In the next step:
CONVERT(C5, “C”, “F”)

Using CONVERT Function in Multiple Cells

Step 02: Display the Results

  • Now, click ENTER and drag the Fill Handle tool.

Using CONVERT Function in Multiple Cells - How to Convert Units in Excel

  • Thus, converting the entire column from degree Celsius to degree Fahrenheit.

Using CONVERT Function in Multiple Cells How to Convert Units in Excel

Let’s apply the CONVERT function in the case of another dataset where the Distance in kilometers among various cities is provided in the USA.

Dataset 2

Now, we want to convert the distance in kilometers between the cities to miles using Excel’s CONVERT function.

Convert Function

Step 01: Enter the Arguments

  • Firstly, select the E5 cell and type CONVERT.
  • Then, provide the following arguments:

CONVERT(D5, “km”, “mi”)

Here, D5 refers to Distance (Kilometers), “km” and “mi” indicate the short form of Kilometer (from_unit argument and Mile (to_unit argument) respectively.

Convert Function - How to Convert Units in Excel

Step 02: Show the Converted Results

  • Secondly, press ENTER to show the result in miles.

Convert Function - How to Convert Units in Excel

  • Next, use the Fill Handle tool to drag down and complete the table and you’ll see that Distance (Kilometer) is converted into Distance (Miles).

Convert Function - How to Convert Units in Excel

Here, I have skipped some of the relevant examples of the CONVERT function which you might explore if you want.’

Read More: How to Convert Meters to Miles in Excel


2. Preparing a Conversion Matrix to Convert Units 

The matrix style conversion or a conversion table can show a vast array of related units of conversion. In this case, we are going to use the dataset shown below.

Dataset 3

Steps:

  • Firstly, type in a numerical value in the C15 cell.

Conversion Matrix - How to Convert Units in Excel

  • In this example, the value 100 was provided in the C15 cell.
  • Excel automatically generates the table in order to show the equivalent value of 100 teaspoons in different units.

Conversion Matrix - How to Convert Units in Excel

Read More: Convert Cubic Feet to Cubic Meters in Excel


3. Applying VBA Code to Convert Units in Excel

Conversion using VBA is a simple process. Just follow along.

Step 01: Navigate to Visual Basic

  • Firstly, look for the Developer tab in the Home ribbon.
  • Then, select Visual Basic from the Developer tab.

Conversion With VBA

Step 02: Open a Module and Run the Code

  • Secondly, go to Insert and click on Module.

Conversion With VBA - How to Convert Units in Excel

  • Immediately, a window appears on the right.
Sub Convert_VBA()
    Dim k As Integer
    For k = 5 To 14
        Cells(k, 4).Value = Application.WorksheetFunction.Convert(Cells(k, 3).Value, "C", "F")
    Next k
End Sub
  • Next, copy and paste this code into this window.

Conversion With VBA - How to Convert Units in Excel

  • Finally, select Run from the top ribbon and close the window.

Conversion With VBA - How to Convert Units in Excel

  • Lastly, return back to your spreadsheet where you’ll find the temperature converted to degree Fahrenheit.

Conversion With VBA - How to Convert Units in Excel


Things to Remember

  • Excel’s CONVERT function is case-sensitive.
  • In addition, the CONVERT function will display the #N/A error if the units are inconsistent.

Incorrect Data Type

  • Lastly, the CONVERT function also throws the #NAME? error if it is unable to recognize the string of text.

Incorrect Data Type


Download Practice Workbook


Conclusion

This article illustrates the process of how to convert units in Excel. Make sure to download the practice files & do it yourself. Please inform us in the comment section if you have any queries. We, the Exceldemy team, are happy to answer your queries.


Related Articles

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo