Explanation

Excel provides two useful tools for working with messy or combined data:

• Text to Columns — splits data from one column into multiple columns.
• Flash Fill — automatically recognizes a pattern and fills the remaining data.

Example

Suppose a column contains:

You can split it into:

Practice

Identify situations where data needs to be:

1. Split into columns.
2. Automatically completed based on a pattern.