Parse text for numeric

I have a column that is entered as feet in the format 4 x 4 x 8
The customer has asked for me to provide that data in inches. Is there a simple way to use left, right and mid where instead on left number of characters it was find the x and go back from that point, ie the first x is at char 3 so I would want left 3-2, mid would be between the x x -2 and right would be the last x plus number of characters fo the end?

Thanks
Alan

This macro will do the calculations for you.
Data begins in cell A1 and must be in the format
you provided, i.e. "4 x 4 x 8". Results are put in
columns B, C & D.

Sub Macro1()
Dim MeasurmentsInFeet
Dim j As Integer, k As Integer

    j = 1
    With Sheets("Sheet1")
        Do While .Cells(j, 1).Value <> ""
            MeasurmentsInFeet = Split(.Cells(j, 1).Value, "x")
            For k = 0 To UBound(MeasurmentsInFeet)
                .Cells(j, k + 2).Value = CInt(MeasurmentsInFeet(k)) * 12
            Next
        
            Set MeasurmentsInFeet = Nothing
    
            j = j + 1
        Loop
    End With
    
End Sub