Converting Feet-Inches to Inches Excel

Question

Hi I have a large excel spreadsheet that contains the heights of different athletes in the form of

6' 4.25"
6' 2.75"

I'm at a loss as to how to get all of these heights into precise inches using a single calculation. Any help would be greatly appreciated.

Answer 1

We must parse the data because these are string texts rather than actual integers. The components of the string will be extracted and converted to numbers using the following:

=LEFT(A1, FIND("'",A1)-1)*12 + MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1)