Converting Feet-Inches to Inches Excel
Hi I have a large excel spreadsheet which contains heights of different athletes in the form of
6' 4.25"
6' 2.75"
I am stuck on trying to find a single formula that can convert all of these heights to strictly inches.
Any help would be greatly appreciated.
Solution
Because these are string text and not actual numbers we need to parse the data. The following will grab the parts of the string and convert to the number:
=LEFT(A1, FIND("'",A1)-1)*12 + MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1)
- Need help to extract this XML node - Excel connection strings in Python
- Shift the range up after clear contents
- Enter Cell Formula using VBA
- Content is out of order when using Excel VBA to create a Word document
- Trouble with Vlookup on power queries?
- excel - hyperlink to sheet based on cell value
- Accessing a Variant/Object/JScriptTypeInfo property in VBA
- Move data to another table based on array value
- Partial exists in dictionary
- Name on Envelope
- Sorting data algorithm 900000 rows of data
- Expression.Error: We cannot apply operator & to types Number and Number
- Importing/scraping an website into excel
- Scraping Morningstar web page
- How do I get my For Next loop to actually loop
- Figuring out the number corresponding to a letter of the alphabet?
- how to select worksheet name from cell
- Npoi Round Formula
- How to get the sheet name from Application.Caller?
- How to declare variable by using for-next loop
- Apache POI Excel - how to configure columns to be expanded?
- How To Copy/Cut Row of Data Based on TRUE/FALSE Condition
- Workbook "Calculation Options" stays in Manual no matter the operation (open, save, close) being performed unless approved user hits Calculate
- Excel automate dynamic number of row generation from another set of data
- How to put sum of dataframe column in certain cell of excel sheet?
- Remove all special characters except space
- Excel is stripping leading 0's from CSV files
- Excel Button for a par sheet
- Remove border between Excel and PPT for a copy and paste VBA
- List of data.frame's to individual excel worksheets - R