In the world of data cleaning, two approaches often stand out: Python, the go-to for coding enthusiasts, and Excel’s Power Query, a code-free, user-friendly alternative.

We’ll cover str.split in more detail later, but essentially, what we’re doing is splitting our data based upon whitespaces within the string, then counting the number of component parts.