CSV files in Excel: How to convert a comma-delimited file to a semicolon-delimited file, and vice versa

A CSV file is a plain text file used to store and transfer data between different, often incompatible, applications and systems. In these plain text CSV files, each line of text is a data record. Also, each line of text (i.e. each data record) consists of one or more fields, separated by delimiters. Those delimiters are originally commas [,], hence the name comma-separated values (CSV). However, data can in principle be delimited with a variety of special characters. Since comas

Top 10 lists in Excel

When analyzing large amounts of data in Excel, the best approach often is to retrieve top (10) values. Consider the following example: Here, we have a table with the invoices from the 29th of January. There are 904 invoices for that day. Values in the invoice column are unique as those are invoice numbers. Values in the user column are not unique, as some users have multiple invoices on that day, and values in the team column are not unique

How to customize the Quick Access Toolbar

The Quick Access Toolbar is a customizable toolbar independent of the tab on the ribbon that is currently displayed in Microsoft Excel. It is usually located in the title bar of the Excel window, but it can also be configured to display below the ribbon. It will look something like this on a new installation: You can see often used commands Save, Undo and Redo already on the toolbar. If you want to remove those, or more likely, add some

Remove Duplicates feature

You will sometimes want to retrieve unique values from a data set – i.e., to find and remove duplicate values. While there are a few ways to do this, the most effective option is Excel built-in feature Remove Duplicates. Remove Duplicates feature removes duplicate rows from the selected columns. Duplicate rows are deleted in this process. The simplest example of this process is removal of duplicate values from a single column: In this example, we’ve started with the data in

Custom Icons for Conditional Formatting

With conditional formatting, among other things, we can join indication icons to our numbers. While we can rearrange available icons as we wish, choice of available icons is fairly limited: In particular, while Green Arrow Up and Red Arrow Down are available, we don’t have available often requested Green Arrow Down and Red Arrow Up. We can expand our choice of icons with the help of the Wingdings fonts – a series of fonts that render characters as a variety