I have a spread sheet that was filled out prior to me getting it and needing to convert all the data into usable information. The cells are filled out like this: 24' - 8 3/16" All the data is spaced out the same and with the ' symbol after the feet, a space before and after the - , and 2 spaces between the inch and fraction of an inch.

I would like to convert these values into decimal feet. Also the data is in rows not columns, so I would like the conversion to be shown in the cell below.

Any help would be greatly appreciated,

Thanks in advanced