This tutorial will demonstrate how to convert values given in centimeters to inches in Excel & Google Sheets.

convert cm to inches

Using the CONVERT Function

The CONVERT function is the best method to convert values given in centimeters to inches. We just need to enter both the value and measurement types into the function. We can use the abbreviations of the measurements.

Let’s test the formula on an example for better understanding. Say in column B we have some values given in centimeters that need to be converted to inches. So, just type the following formula in cell C4 and drag it down:

=CONVERT(B5,"cm","in")

convert function cm to inches

By changing the values in Column B, the Column C values will update automatically.

Conversion of Values in Inches to Centimeters

Just by switching the measurements arguments, we can convert the values given in inches to centimeters:

=CONVERT(B3,"in","cm")

convert inches to cm

Convert Values in Centimeters to Inches in Google Sheets

The conversion of centimeters to inches using the CONVERT Function works the same in Google Sheets as in Excel:

convert cm to inches google sheets