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 127 views

## 1 answer to this question.

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)
``` • 50,080 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