Convert inches to centimenters

New Contributor

Help, I need to come up with a way to convert the size of household goods - as in length, width, and height to from inches to centimeters - US Imperial to Metric.  Does anyone have a formula that would include having the text "X" to parse.



7 Replies


Start typing =CONVERT(10,

and after the comma select what and after next one into what to convert.

@SamPaws359 Perhaps like this:

Screenshot 2021-03-01 at 15.47.17.png


Edit: Ooops @Sergei Baklan You beat me to it!

@Riny_van_Eekelen But you give an example. One to another.

@Sergei Baklan 

Thank you

thank you

@SamPaws359 , glad it helped