To split text on several separators at once, put them all inside one pair of quotes: =SPLIT(A2, "-/ "). By default SPLIT treats each character in that text as its own separator, so a dash, a slash and a space all cut the string. The two optional arguments after it, split_by_each and remove_empty_text, change that behaviour.
What are the four arguments of SPLIT?
The full syntax is SPLIT(text, delimiter, split_by_each, remove_empty_text). The last two take TRUE or FALSE, and both default to TRUE.
| Argument | What it controls | Default |
|---|---|---|
| text | The cell or string to cut | Required |
| delimiter | The character or characters to cut at | Required |
| split_by_each | TRUE treats every character in the delimiter as a separate separator; FALSE treats the whole delimiter as one block of text | TRUE |
| remove_empty_text | TRUE drops empty pieces created by back-to-back separators; FALSE keeps them as blank cells | TRUE |
How do I split a messy NEFT-style narration?
Say A2 holds this made-up narration: NEFT-ABCD0123456-RAVI KUMAR-RENT/NOV. It uses dashes between most parts and a slash before the month. Splitting on both is a one-liner.
- =SPLIT(A2, "-/") returns NEFT, ABCD0123456, RAVI KUMAR, RENT and NOV, five cells in all.
- The space between RAVI and KUMAR was not in the separator list, so the name stays in one cell.
- =SPLIT(A2, "-/ ") adds a space to the list and returns six cells, because RAVI and KUMAR now land in separate cells.
Pick the list to match the answer you need. For a payee name you usually want it whole, so leave the space out. For counting words or checking each word, add it.
What does remove_empty_text change?
Narrations often contain doubled separators, such as NEFT--ABCD0123456- RAVI KUMAR. With the default TRUE, the empty piece between the two dashes is thrown away, so columns stay lined up. Write =SPLIT(A2, "-", TRUE, FALSE) instead and the empty piece is kept as a blank cell. That is useful when the bank always leaves a field blank on purpose, and you want each field to sit in the same column on every row.
Note the order of the arguments. To turn off removal of empty pieces you must also give a value for split_by_each, which is why TRUE comes first in that example.
When would I set split_by_each to FALSE?
Use FALSE when the separator is a multi-character string, such as a space-dash-space between the fields. With =SPLIT(A2, " - ", FALSE), the text is cut only where the exact three-character block appears, so a hyphen inside a name or a single space inside a merchant name does not split anything.
| Formula | Input | Result |
|---|---|---|
| =SPLIT(A2, " - ", FALSE) | RAVI KUMAR - RENT - NOV | RAVI KUMAR, RENT, NOV |
| =SPLIT(A2, " - ") | RAVI KUMAR - RENT - NOV | RAVI, KUMAR, RENT, NOV (spaces and dashes each cut) |
How do I tidy the results afterwards?
Splitting on a space or a list of characters can leave stray spaces at the edges of pieces. Wrap the split in ARRAYFORMULA and TRIM: =ARRAYFORMULA(TRIM(SPLIT(A2:A500, "-/"))). TRIM removes leading and trailing spaces, and collapses repeated spaces inside a piece. The result then matches cleanly when you later look a merchant up in another table.
If the layouts vary too much for one separator list, a different route is to standardise first. =SPLIT(SUBSTITUTE(SUBSTITUTE(A2, "/", "-"), " - ", "-"), "-") swaps slashes and padded dashes for plain dashes, then splits once.
Before you trust the columns
- Test on five narrations of each payment type, because NEFT, IMPS and UPI rows rarely share a layout.
- Confirm the merchant or payee is in the same column for every test row.
- Check that a 12-digit reference has not turned into a rounded number, which can happen when text that looks numeric is converted.
- Keep the raw narration column untouched next to the split results.
Spreadsheets handle this well while the volume is small. When you are reconciling several months across more than one account, an app that categorises transactions from an uploaded statement, such as SpendixAI, can take over the tedious part while you keep the review step.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

