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.

Oct 15, 2022 in Others 1,329 views

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

• 63,720 points

Converting feet & inches (e.g., "5 ft 1 in") to decimal feet using VBA or Excel

I have a database with a few ...READ MORE

MS EXCEL: Convert (Height) Decimal Feet & Inches to Inches Only

Using MS Excel (2010), I would like ...READ MORE

Excel automatically converting 7 digit CAS number to another number (date?)

Looks like you could use: The formula in D2: =SUBSTITUTE(F ...READ MORE

Java Spring - Writing Excel file and converting to PDF

Since you are using Spring I suggest ...READ MORE

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE