Split String Value

[Ninja2k]

I need to take my box dimensions from Sheet 2 and rewrite them in a new format so I can add them to a CMS. For example

Box Dimensions
32.9 cm x 22.1 cm x 3.062 cm

Becomes
Width: 32.9 cm Depth: 22.1 cm Height: 3.062 cm

Is there a formula that can do this?

[Ace_XL]

Use

=SUBSTITUTE("Width: "&SUBSTITUTE(A2,"x","Depth:",1),"x","Height:")

[Ninja2k]

Worked fine, thanks!