Convert or split then combine numbers from cell

[bernardazar]

Hello!

I have plenty of cells with dimensions in the following format:
100x50cm

I am looking for an efficient way to convert those to inches, so the result should look like 39x20" inches. I am looking for a formula that could convert it directly or indirectly, perhaps by first splitting the numbers in two separate cells, convert the numbers to inches and then combine the numbers together like so 39x20" inches.

100x50cm --> 39x20" inches

Any smart idea how to do this?

Note: in order to convert a cm value to inches, the cm value should be divided by 2.54.

 

[Rick Rothstein]

Two questions...

1) Are your existing dimensions always cm or could you mm or even m as possibilities?

2) Do you always want your converted value rounded to the nearest whole number as your example seems to suggest?