Convert Centimeters to Inches in Excel & Google Sheets
Download the example workbook
In this Article
This tutorial will demonstrate how to convert values given in centimeters to inches in Excel & Google Sheets.
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")
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 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:
