How to Split camelCase / PascalCase in Excel
Field names and system codes arrive smushed together — firstName, getUserID, XMLHttpRequest. To make them readable labels you need to split at each case change, and the tricky bit is not breaking acronyms. Here's how.
Last updated: August 2026
| Identifier | Readable | |
|---|---|---|
| firstName | → | first Name |
| getUserID | → | get User ID |
| XMLHttpRequest | → | XML Http Request |
Method 1 — a helper formula (365)
You can loop over characters with REDUCE/MID to insert a space before each capital, but the formula is long and fragile — and a naive "space before every capital" turns XMLHttp into X M L Http, mangling acronyms.
Method 2 — a VBA macro
A regex macro ([a-z][A-Z] → insert space) is the usual answer, but macros are blocked in many corporate workbooks and behave differently on Excel for the web and Mac.
The 1-click way — Tellsheet
Split by Case Change breaks identifiers at their real boundaries — camelCase, PascalCase, and acronym edges (XMLHttpRequest → XML Http Request). Add spaces mode rewrites the cell in place with a separator you choose; into columns mode puts each word in its own column. It also breaks on existing _ - and spaces, and can optionally split between letters and digits. Pairs with Change Case and Split Names.
Frequently asked questions
How do I split camelCase in Excel?
A long 365 formula or a VBA macro, or Tellsheet's Split by Case Change in one click.
Does it handle acronyms?
Yes — XMLHttpRequest → "XML Http Request", keeping XML whole.
Columns or spaces?
Both — "add spaces" rewrites in place; "into columns" splits each word out.
Does it need macros?
No — it runs everywhere Tellsheet does.
Related Excel guides
Make machine names readable
Split by Case Change turns getUserID into "get User ID" — acronyms intact — inside Excel.
Get Tellsheet free See pricing