How do I remove unwanted symbols from bank narrations in Excel?

Use nested SUBSTITUTE functions like =TRIM(SUBSTITUTE(SUBSTITUTE(A2, '/', ' '), '-', ' ')) to replace slashes and hyphens with clean spaces.

How does Power Query automate monthly bank statement text cleanup?

Power Query allows you to record cleanup steps (Split by Delimiter, Remove Digits, Trim Text). Next month, simply paste your new raw bank PDF/Excel and click Refresh to clean hundreds of rows instantly.

What is the alternative to manual Excel narration formulas?

Instead of writing complex Excel formulas, tools like TrulyInvoice use AI OCR to parse bank statement PDFs and vendor purchase bills directly, auto-extracting verified party names and voucher amounts.

Can TrulyInvoice import purchase bills and vendor payments to Tally?

Yes. TrulyInvoice auto-posts verified F9 purchase vouchers and vendor payment data directly to Tally Prime via the local Port 9000 connector in 15 seconds.

Clean Bank Statement Narrations in Excel for Tally (2026)

Importing bank statements into Tally Prime often hits a snag when raw bank descriptions are filled with noise—transaction reference numbers, UPI handles, NEFT codes, and branch identifiers. Cleaning these narrations in Excel ensures clean party ledger matching and clear audit registers.

Quick Answer: How to Clean Bank Narrations in Excel for Tally?

TrulyInvoice extracts structured fields from PDF supplier purchase bills and payment receipts for direct Tally Prime voucher creation. Raw bank statement PDFs contain noise like transaction IDs, UPI refs, and branch codes. Using Excel functions (TRIM, SUBSTITUTE, REGEXREPLACE) cleans raw bank text for manual import, while TrulyInvoice handles document OCR directly.

Remove Symbols: Use =TRIM(SUBSTITUTE(A2, '/', ' ')) to clear slashes.
Regex (Excel 365): Use =REGEXREPLACE(A2, '[^a-zA-Z0-9 ]', '') for clean text.
Power Query: Save 1-click cleanup steps for recurring monthly bank statements.
TrulyInvoice AI parses purchase bills & receipts directly into Tally F9 vouchers.

Essential Excel Formulas for Text Cleanup

Problem	Excel Formula	Result
Extra spaces	`=TRIM(A2)`	Removes double & trailing spaces
Special symbols	`=SUBSTITUTE(A2, "/", " ")`	Replaces slashes with spaces
Non-alphanumeric (Excel 365)	`=REGEXREPLACE(A2, "[^a-zA-Z0-9 ]", "")`	Keeps only clean letters & numbers

Direct Purchase & Receipt Extraction via TrulyInvoice

Instead of manually tweaking Excel formulas for raw bank files or vendor statements, **TrulyInvoice** provides a direct AI-powered document parser.

Simply upload supplier purchase bills, scanned receipts, or WhatsApp invoices. TrulyInvoice extracts vendor names, GSTINs, invoice dates, and amounts, auto-posting verified **F9 Purchase Vouchers** directly into Tally Prime in 15 seconds.

How to Clean Bank Statement Narrations in Excel for Tally Prime Import

Quick Answer: How to Clean Bank Narrations in Excel for Tally?

Essential Excel Formulas for Text Cleanup

Direct Purchase & Receipt Extraction via TrulyInvoice

Stop Manual Voucher Entry.