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