When Text to Columns Helps
Sometimes statement text arrives in Excel with every transaction crammed into a single cell, for example after pasting from a web page or a text file. Each line might hold a date, a description and an amount all joined by commas. Microsoft documents the Convert Text to Columns Wizard as a way to split text from one cell or column into several columns.
The invented lines below show the situation. Each one is in column A, one transaction per row:
2026-09-02,Fresh Basket Market,-42.10
2026-09-03,Metro Ride,-18.50
2026-09-05,Salary Deposit,1500.00The Steps Microsoft Documents
The Microsoft page gives this delimited workflow. First select the cell or column that holds the text. Then go to the Data tab and choose Text to Columns. In the wizard, choose Delimited and then Next. Pick your delimiters, with Comma and Space given as examples, and watch the Data preview window, which shows how the split will look. Click Next, choose the Destination, which is the worksheet location where the split data should appear, and click Finish.
For the sample lines, choose Delimited and tick Comma only. The preview should show three columns: the date, the description and the amount.
Choosing the Right Delimiter
The delimiter is the character that marks where one column ends and the next begins. Pick the one that actually separates fields in your text. With Comma ticked, the first sample line splits at its two commas into 2026-09-02, Fresh Basket Market and -42.10.
If you also tick Space, every space becomes a split point as well. The description Fresh Basket Market would then spread across three columns, and the line would end up in five columns instead of three. Watching the Data preview before you click Next is how you catch this, and it is the reason to tick only the delimiters you need.
Use the Destination step to send the split data to empty cells beside the original text. That leaves the source column untouched while you check the result.
Check the Result
After the split, confirm the amounts are numbers and the dates are dates, not text. A quick check is to sum the amount column. For the three sample lines, the total should be 1439.40, from -42.10 plus -18.50 plus 1500.00. If the sum returns 0 or a different figure, some amounts are still stored as text.
The Microsoft page used for this article covers the basic delimited workflow only. It does not describe fixed-width splitting, text qualifiers or per-column data formats, so check those options in the wizard yourself if your text needs them, such as descriptions that contain commas.
When There Is Nothing to Paste
Text to Columns is a repair tool for pasted text. If your statement is only available as a PDF, PDFtoRow converts bank statement PDFs to Excel or CSV and offers a free preview of the first 10 rows.
Convert Bank Statement PDFs Cleanly with PDFtoRow
Tired of fixing broken columns, corrupted dates, and numbers stored as text? PDFtoRow extracts transaction tables directly from digital PDF vector layers, preserving check numbers and outputting true numeric amounts. Statements up to 5 pages are free once per email every 24 hours. Check the 10-row preview before you download.
Frequently Asked Questions
Microsoft documents it on the Data tab. Select the cell or column with the text, choose Text to Columns, then follow the Convert Text to Columns Wizard.
Microsoft lists Comma and Space as examples of delimiters you can pick, and the wizard has a Data preview window that shows how the split will look.
In the Destination step you choose the worksheet location where the split data should appear, then click Finish.
Primary Evidence & Official References
- Split text into different columns with the Convert Text to Columns Wizard - Microsoft Support — support.microsoft.com (Verified 2026-10-29). Official source documentation →