Hi,

I have several hundreds of product size / dimensions that are in 1 column under the following format:

Height x Length x Width .... all in mm and need to convert to inches ... but that's not all:
- Some cells are mixed, so instead of dimensions being in a single order such as HxLxW they can be a different order, like LxWxH or HxWxL, etc.
- Some are with the following format: "211mm x 456mm x 422mm"

This is a single problem but can see two separate issues here.

I've tried a two-dimension solution:
=LOOKUP(99^99,--LEFT(A1,ROW($A$1:$A$10)))&"x"&25.4*LOOKUP(99^99,--RIGHT(A1,ROW($A$1:$A$10)))/25.4

which works well grabbing the "H" and the "W" of my original example, but cannot grab the 3rd dimension ...

This initially seems a bit of a trivial issue but now I'm out of ideas and could truly use some help.

Thanks,

Rod