Return to Excel Formulas List

Convert Centimeters to Inches in Excel & Google Sheets

Download Example Workbook

Download the example workbook

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

convert centimetres to inches

 

CONVERT Function

The CONVERT function is the best method to convert centimeters to inches. Simply enter both the value and measurement types into the function.

 

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

convert function cm to inches

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(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