How to Split Fixed-Width Data in Excel
Legacy mainframe, COBOL and bank exports pack each field into a fixed number of characters, and Excel's fixed-width wizard is a fiddly ruler you re-set every time. Here's why, and the one-click way.
Last updated: August 2026
| Before | After | |
|---|---|---|
| ABC12345 | → | ABC | 1234 | 5 (widths 3, 4) |
| XYZ98765 | → | XYZ | 9876 | 5 |
Why the wizard is fiddly
Excel's Text to Columns does have a fixed-width mode, but it's a modal ruler you drag break lines on by hand and re-set from scratch every single time — there's no way to save the widths. Worse, like its delimited sibling it overwrites the neighbouring columns without warning. For files you re-import regularly, that's a slow, error-prone ritual.
The 1-click way — Tellsheet's Fixed-Width Parser
Select the column and run Fixed-Width Parser. Type the field widths as numbers — say 3, 4 — and it cuts each row at those positions into new columns, with the last field taking whatever remains, so ABC12345 becomes ABC, 1234, 5. An optional trim strips the space padding these records usually carry, and your other columns are never touched. Pairs with Split Text into Columns and Split Address into Columns.
Frequently asked questions
How do I set the field widths?
Type them as numbers, like 3, 4 — the parser cuts each row at those character counts.
What happens to the last field?
It takes whatever remains after the listed widths, so you needn't count the tail exactly.
Does it overwrite my other columns?
No — it writes to new columns and leaves neighbouring data intact, unlike Text to Columns.
Can it trim spaces?
Yes — an optional trim removes the space padding fixed-width records usually carry.
Related Excel guides
Split fixed-width data in one click
Fixed-Width Parser cuts each row by field widths into new columns — no modal ruler to re-set, nothing overwritten.
Get Tellsheet free See pricing