Why Fused Date and Description Cells Occur
When bank statement tables are converted from multi-column PDF layouts or poorly formatted text feeds, the transaction date and payee description frequently collapse into a single table cell (for example, "10/14/2026 AMAZON.COM*SEATTLE WA" or "15-OCT-2026 DIRECT DEPOSIT").
Having dates and descriptions fused together halts downstream accounting processes: Excel cannot sort transactions chronologically, filter by month, or recognize dates for pivot table grouping. Separating them into discrete columns is an essential first cleanup step.
The best method depends on your version of Excel. TEXTBEFORE and TEXTAFTER provide the cleanest solution in Microsoft 365 and Excel 2024. For perpetual versions like Excel 2021, 2019, or 2016, use standard string slicing formulas or Text to Columns.
Method 1: Modern Excel (Microsoft 365 & Excel 2024 Only)
In Microsoft 365, Excel 2024, and Excel for the Web (version 2208 or later), the TEXTBEFORE and TEXTAFTER functions allow immediate splitting based on the first space character delimiter.
Assuming your combined text is in cell A2:
Extracting the Date String (Cell B2):
=TEXTBEFORE(A2, " ")Extracting the Description String (Cell C2):
=TEXTAFTER(A2, " ")These dynamic functions automatically handle both short dates ("1/2/2026") and standard dates ("01/02/2026") without needing fixed position counts.
Method 2: Classic Excel Formulas (Excel 2021, 2019, 2016, and Older)
If your organization uses standalone versions of Excel where TEXTBEFORE is not supported (#NAME? error), use standard string manipulation functions.
When statement dates use a uniform 10-character format (YYYY-MM-DD or MM/DD/YYYY):
Extract Date string:
=LEFT(A2, 10)Extract Description string:
=TRIM(MID(A2, 12, LEN(A2)))If date character lengths vary (e.g., single-digit days like "1/5/2026"), find the first delimiter space dynamically using the SEARCH function:
=TRIM(MID(A2, SEARCH(" ", A2) + 1, LEN(A2)))Converting Extracted Text to Genuine Date Serial Numbers
Text extraction formulas return text strings, not true Excel date numbers. Text dates align to the left side of cells and will not sort correctly across calendar years.
To force Excel to evaluate the text as an authentic calendar date, wrap your extraction formula in DATEVALUE or use a double unary operator (--):
=DATEVALUE(LEFT(A2, 10))After entering the formula, format the cell as a Date (press Ctrl + 1, select Number > Date, and choose your preferred regional format such as YYYY-MM-DD). The date will align to the right, confirming Excel recognizes it as an authentic numeric date serial number.
Method 3: The Text to Columns Wizard (No Formulas)
If you prefer a direct interface method without writing formulas:
1. Insert an empty column next to your combined column to avoid overwriting adjacent data.
2. Highlight the combined date and description column.
3. Go to Data > Text to Columns.
4. Select Delimited and click Next.
5. Check "Space" and check "Treat consecutive delimiters as one". Click Next.
6. On Step 3, highlight the first column in the data preview, choose Date, and select your date format order (MDY, DMY, or YMD). Click Finish.
7. If descriptions contain multiple spaces, merge remaining description columns using =TEXTJOIN(" ", TRUE, Range) or concatenate them.
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
A 5-digit number indicates Excel successfully converted your date into its underlying serial number (days elapsed since January 1, 1900). Simply format the cell as Date (Ctrl + 1 > Date) to display it as a readable calendar date.
Standard DATEVALUE recognizes 12-OCT-2026 in English Excel locales. If your system locale differs, use MID to isolate the month and a lookup table to translate month abbreviations to numbers.
Primary Evidence & Official References
- Microsoft Support: TEXTBEFORE Function — support.microsoft.com (Verified 2026-10-19). Official source documentation →
- Microsoft Support: DATEVALUE Function — support.microsoft.com (Verified 2026-10-19). Official source documentation →