Blog & Excel Tips

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.

When using CSV files you may find that the CSV's are losing leading zeros when you open them. This is happening because Excel is assuming that if it is a number, it cannot having leading zeros so it just removes them.

2021 dates for our MS Excel training courses. These dates are for the public live and virtual Excel courses for Johannesburg and Cape Town (for the live- virtual can attend from anywhere).

Determining the difference between 2 dates in Excel is a very common requirement. From a straight number of days, to workdays, to months/ years or fraction of a year, all the date difference options