Blog & Excel Tips

How to manually find all the Excel functions prone to spreadsheet errors and a listing of the high risk functions with their likely error.

... sometimes you want to find which cells in Excel are using external links. This could be so that you can delete them, remove the link or just better understand what impact the external links are having on your spreadsheet. This post is a description of how to find cells with external links in excel.

You may come across situations where you need to use a line break as the delimiter in Text to Columns in Excel. A line break is where, within a single cell, text appears on two seperate lines.

How to use multiple characters as delimiters in Excel's Text to Column tool, when Excel only allows a single character entry.

Suddenly your Excel CSV's are now semicolon not comma. You can change this back to be a comma or else you can learn how to use semi colons instead of commas for CSV's.

If you are forced to repair an Excel file and save it as a new version, it is useful to know what is lost when repairing a corrupt Excel file.

How to switch off the PowerQuery Conditional Column wizard when you want to edit a formula in the Custom Column wizard.

You work often on CSV files in Excel and suddenly the CSV uses semicolon instead of comma, or comma instead of a semi colon. This sometimes happens when you have changed computers or if you receive the CSV file from a different source.