I have imported a column of data from another program that is in feet and
inches (1' 7"). There is a space separating the values. I need to average
this column. It is not that important on the final format. It doesn't have to
be in feet and inches. How can I do this without manually converting each
cell?