I have a column with several thousand heights, in different formats, that I would like to convert to inches.

Examples from actual data:

5 ft 2 in

6 feet 3 inches

6ft 3 inches

6 feet 3"

5*8

5.3

5'10"

5 71/2

I'm thinking there is some way to get the feet in one column and the inches in a second to calculate inches. Feet seems easy, with LEFT, but I'm not sure how to reliably get the inches in another column.

What's the best way to do this?

`5 ft 2 in`

,`6 feet 3 inches`

,`5*8`

(for five feet eight inches?),`5.3`

(is this 5 foot three inches, or 5.33333 feet?)5more comments