Knowledge base

Here is the email sent to all subscribers on 10 June 2021. To receive Excel top tips just like this, you can subscribe by clicking here....

I have a warning message When does it happen? Can you send a screenshot to us? Also, if you can, please email the PDF input document to...

Ever come across a bank statement with transactions that flow to the next line? These are tricky to extract into Excel, as the last...

A statement format that looks nice, but makes extracting transactions difficult is showing two dates in the same column like this: See...

Here is the email sent to all subscribers on 22 April 2021. To receive Excel top tips just like this, you can subscribe by clicking...

If you can't select the text in your PDF bank statement, then you have a scanned image. To extract your transactions with StatementReader...

Select the text from your PDF bank statement, copy, then paste into notepad - if you see gibberish or different characters in notepad,...

Here is the email sent to all subscribers on 31 March 2021. To receive Excel top tips just like this, you can subscribe by clicking...

Lloyds TSB send out bank statements like this: Some of the text here is searchable, and some is an image, so the OCR engine skips the...

A selection of bank templates from India and UAE have been added in the latest release of StatementReader - helping you to get more...

Here is the email sent to all subscribers on 4 March 2021. To receive Excel top tips just like this, you can subscribe by clicking here....

Here are the latest templates to be added to StatementReader for banks from UK, UAE, Switzerland, Hong Kong, India, USA, New Zealand:...

Here is the email sent to all subscribers on 28 January 2021. To receive Excel top tips just like this, you can subscribe by clicking...

My starter scripts in January 2021: Track changes in Excel My most hated feature of Excel is tracked changes. Tracked changes in Excel...

My starter scripts in January 2021: Set the file attributes for multiple Excel files Setting file attributes for multiple files in one...

My starter scripts in January 2021: List Excel file attributes in Excel File attributes of Excel files (the file properties accessible on...

My starter scripts in January 2021: Split Excel file into separate files As an extension on yesterday’s problem (combining multiple Excel...

My starter scripts in January 2021: Combine multiple Excel files from a folder I always advocate finding a problem early on when picking...

We have now removed the need to have Excel installed on the user's machine; this improves the availability and stability of...

My exploratory data analysis of Land Registry data in November 2020: The highest number of inter-country transfers over a 5-year period...