Download the example workbook
This tutorial will demonstrate how to convert centimeters to inches in Excel & Google Sheets.
The CONVERT function is the best method to convert centimeters to inches. Simply enter both the value and measurement types into the function.
Note: Enter the formula in cell C4 and drag it down.
Convert Inches to Centimeters
By switching the measurements arguments, we can convert the values given in inches to centimeters:
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: