CODEWITHSUNDEEP
excelexcel-2003
user2938627
user2938627

Reputation: 11

Converting inches to centimetres

I have a list of dimensions with the " symbol that I want to convert to cm. For example:

104" X 110"
87" x 110"
78" x 80" x 15"
60" x 80" x 15"

Upvotes: 1

Views: 152

Answers (1)

pnuts
pnuts

Reputation: 59485

Replace X with x and " with nothing. Apply Text To Columns with x as delimiter. Enter 2.54 into a spare cell and copy that cell. Select all your data and Paste Special Multiply. Stitch results back together with concatenation (for the same format as input) or with multiplication to get areas/volumes.

Upvotes: 3

Related Questions