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?)