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 Function
The CONVERT function is the best method to convert centimeters to inches. Simply enter both the value and measurement types into the function.
|
1 |
=CONVERT(B5,"cm","in") |
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:
|
1 |
=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:
