With the Microsoft Excel spreadsheet from the Office suite, we can perform countless calculations that even today, after years of use, we do not know. Of course this with the help of functions and formulas and one of them is the well-known convert function. And in this article we are going to teach you a practical method that will allow you convert mediated easily in Microsoft Excel step by step.
If we learn to use the convert function, we can transform one measure into another without major complications and without having to perform these calculations yourself.
This operation can be done manually or through the Insert function menu. You can also apply this convert function to an entire column of data.
Of course, we will guide you through all this procedure, so that you can fully understand what you are going to do and do not have the problems that can arise when you try to insert formulas in a text box.
How to easily convert measurements in Microsoft Excel step by step
As we already mentioned, we are going to teach you first to use the convert function manually in your spreadsheet. To carry out this conversion, we are going to have two columns, where Column A contains the data to be converted. And in column B, the already converted data or the result of the conversion.
And to start, we are going to label column A and to do this we are going to go to cell A1 and we are going to click there. And you are going to write the unit of origin, that is, in which unit is this column expressed in meters, inches, etc. And it will represent the From unit component of that function.
Steps for conversion
To make it clearer, we will use this example, you are in cell A1 and you are going to click and then type Metro. And you’re going to convert the number 10 to Feet, where inches is the From unit component and Inches is the To unit component. By using the convert function, you will allow the conversion From the unit to A unit.
You may also be interested in:
The next step is to label column B and to do this we will go to cell B1 and click there. In it we will write the unit in which we want to convert the data in column A, then we will write Inches. And this column will be A unit and it will be will show the conversion results.
The next step is to write in column A in cell A2, a number, which we want to convert, remember you only have to enter numbers. Then we move to column B and in cell B2 we will write the following formula “= convert (A2)“. This formula will convert the data that is contained in cell A2, although you can also write it this way “= convert (10”.
To finish writing the formula you must add the unit of origin and the unit to which you want to convert that data. Then it would be something like “= convert (A2;” m ”;” in ”) or“ = convert (10; ”m”; ”in”) where “M” represents the unit of origin or meter. And “in” represents the unit to which we are going to convert the data, or what is the same to convert 10 meters to inches.
The last step is to press the Enter key and in this way the function can be executed and voila, the searched unit will appear in this cell.
The second method that we are going to show you consists of Insert functionTo do this we will use the same previous example and instead of adding the conversion unit manually, go to the Insert function menu.
To do this we do not go to the Formula tab and then click on Insert function, then choose the cell and then select Convert.
You may also be interested in:
A box will be displayed and in it you must add the following data you can enter the cell or the number to be converted, for example A2 or 10. Now from the unit you are going to write “m” and To unit you are going to write “In”. Finally press the Enter key to execute this function, and the conversion will be displayed in cell B2.
I'm sorry this content was not useful for you!
Let me improve this content!
Tell me, how can I improve this content?