Excel Magic Tricks: Use CONVERT function to convert any measurement units

The CONVERT function in Excel is a built-in function designed to help you convert measurements from one unit to another. It saves you the hassle of performing manual calculations, especially when you have large sets of data that need conversion. The function is flexible and can handle a wide range of measurement units, making it an invaluable tool for anyone dealing with data from different systems of measurement.

How to convert a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

CONVERT(number, from_unit, to_unit)

Number/cell – The value we wish to convert
From Unit – This is the unit you are converting from
To Unit – This is the unit you are trying to convert to

For example, to convert a value in cell A1 to meters, you can use the formula:
=CONVERT(A1, "ft", "m")