So I have a data dump that's supposed to represent a person's height. The data is crap and I'm trying to clean it up. Ultimately, I aim to have a separates fields for feet and inches.

Still using Excel for your data analysis? Learn how to leverage Python so you can work with larger datasets and automate repetitive tasks. Learning to code, whether with Python, JavaScript, or another ...