Explanation

Sometimes data is arranged using fixed character positions rather than delimiters.

Example:

You can use Fixed Width to create separate sections.

Text to Columns Options

1. Delimited
2. Fixed Width
3. Data Preview
4. Column Data Format
5. Destination

Important

Before clicking Finish, check the Data Preview to make sure the columns will be split correctly.

Practice

Use the following data:

Create separate columns for:

Employee ID | Year