How to compare two files in Notepad++?

It often happens, when you have to work with a lot of data, to need to know differences between two sets of text data. A simple solution to know quickly if data set look alike or not, or to have an overview of different lines, is to use Notepad++ text editor as a text file compare tool with an extra plugin, that can be easily installed from the Plugin Manager. It even works to compare two XML files!...
Read more

Notepad++ open file in new window

As you might have noticed, Notepad++ doesn’t offer the option to open a new window, and opens all files in the same one. In order to open a new window, in which you’ll be allowed to open files / create new tabs / drag and drop opened files, simply put your cursor on the tab name of the file you want to open in a new window, click and keep the mouse button pressed, drag the mouse out of the Notepad++ window, release the mouse button – and voilà ! ...
Read more

Notepad++ randomize, sort lines random

Using Notepad++, it is very simple to randomize a list of lines, going from an organized list to a random one, as seen above. To do so, make sure you have installed Python Script plugin – if not, see Notepad++ install Python Script plugin with Plugin Manager. We will then install the RandomizeLines.py for Notepad++ from github. ...
Read more

Painless Excel custom autofilter on more than 2 criteria

If you have an Excel sheet on which you would like to filter on several criteria, you have three different ways, depending if you want to filter on one, two, or multiple criteria, in which case you need to use the advanced filter Excel in addition with Excel wildcards to refine the filters....
Read more

How to solve Bluetooth paired but not connected on Windows 10?

It can happen that a Bluetooth device, such as a headset, which has been previously paired and connected on a Windows installation, is suddenly unable to reconnect, ending up with a Bluetooth speaker paired but no sound. There are several possible reasons to this, and several solutions which should allow you to reconnect your device....
Read more

MSExcel: How to find the position of a character in a string?

Finding the position of a character in a string can be a very simple operation in MSExcel, by using the corresponding built-in function “FIND”. For example, let’s say that we have a list of directories and file names, and only want to get a final result with the file names....
Read more

How to count number of cells and count characters in a cell in Excel?

MS Excel is a good tool for organizational and accounting things and it can be used at any level. It doesn't require a lot of experience, because the tool is making everything seem easy. You can use it for your personal need too, with powerful functions such as advanced Vlookup in Excel, find the position of a character in a string, or also count number of occurences of a string in a file....
Read more

How to properly use Excel String Compare function?

Using MS Excel as an everyday solution, can make your life much easier. It doesn't matter where you work, the way that Excel works, it will get you out of trouble, with plenty of useful simple functions to count number of occurrences, find the position of a character in a string, count digits in cell or count characters in cell for example....
Read more

How to change GIMP language?

The GIMP language can easily be changed by opening the GIMP interface, and going to the menu edit > preferences > interface > language, and selecting the GIMP language to use in the interface, before continuing image editing with simple functions such as drawing straight lines in GIMP, or more advanced functions like batch image resizing with GIMP....
Read more

How to change Outlook calendar weather to Celsius?

How to change Outlook weather to Celsius or change weather to Fahrhenheit? By default, the MS Outlook calendar is displayed in Fahrenheit or in Celsius. The weather unit can be changed, see below how to change weather to Fahrenheit in Outlook, or how to change Outlook calendar weather to Celsius. See also how to change Outlook calendar location after you had change Outlook calendar to Celsius weather unit....
Read more

How to compare 2 CSV files with MS Access

It may happen to end with two different tables, in which you just want to know what are the exact differences, especially when you manage a lot of data. I propose you a simple way to quickly get differences between two tables – the only difficult part is to get them in the right format ! ...
Read more

Paste CSV into Excel

Copy pasting CSV (Comma Separated Values) is pretty easy in Microsoft Excel ! In short : use the Data > Text to Columns option. Starting with a CSV file, like the following one, open it in Excel by using the standard Excel file opening, using keyboard shortcut CTRL+O, or by opening it in Windows Explorer with right clic and selection Open with Excel 2010 / Excel 2013 / Excel 2016, depending on the version you have installed....
Read more

How to delete duplicates in Excel

How to find duplicates in Excel, delete duplicate rows in Excel, and eliminate duplicates in Excel are all the same thing, with one simple function included in Excel to perform data deduplication. Below, we will also propose another solution with an Excel remove duplicates formula, which can also be used to identify duplicates in Excel and hide duplicates in Excel, without necessarily having to eliminate duplicates in Excel....
Read more

Combine columns in Excel and generate all possible combinations

Having two different data sets, for example a customers list and a products list, and want to combine them to get a new list with all possible combinations of customers and products? The solution is pretty simple, feasible with MS Excel in a few minutes, and, even with thousands of entries, doesn't require much effort – much less than copy pasting the second list for each value of the first list – this last solution would take hours with hundreds of entries. See below how to combine Excel columns and generate all possible combinations Excel....
Read more

How to screen record Windows for free with PowerPoint?

That is right, you read well - if you have Microsoft PowerPoint installed on your computer, you can now screen record for free your Windows desktop, with a very good quality. If a PowerPoint presentation is on presentation mode, you can turn the PowerPoint presentation into a video, and otherwise, you can turn anything on your computer into a video, simply by having it being shown on the screen, and including registering your microphone....
Read more

How to turn off Chrome notifications on Windows10?

The Chrome notifications can easily become annoying on Windows10. However, there is an easy way to turn them off, by going to settings > content settings > notifications > block. See below a detailed example to turn off Chrome notifications on Windows 10 - it also world to turn off FaceBook notifications on Chrome, and any other website or push notification that has been activated by mistake, or is not needed anymore....
Read more

Notepad++ install Python Script plugin with Plugin Manager

In order to be able to run a lot of interesting scripts (see Notepad++ randomize, sort lines random), written in Python language in Notepad++, you need to install the Python script plugin. You can either download and install it manually, or install it automatically with the Plugin Manager, that you can find in menu Plugins > Plugin Manager > Show Plugin Manager....
Read more

Batch image resizer with GIMP photo editor batch processing

In various occasions, it is useful to update in one shot a batch of photos. This operation takes a few minutes to setup using the Batch image manipulation plugin for the GIMP. It means processing as many files as you want at once, for example a batch resize will resizer thousands of files in one operation....
Read more

How to download subtitles in VLC

Since a few versions of VLC, there is now a built in option that will search for subtitles of current media file online, download the one selected, and play it with the movie, with only a few clicks. This is achieved by the VLC VLsub extension, which was previously an external plugin, but is now directly integrated in VLC media player....
Read more

Lotus Notes an error was encountered when opening a window

Do not reboot your computer ! All you have to do is to terminate the ntaskldr.exe process. This might happen when hard closing Lotus Notes, for example by terminating the process, or asking Windows to do it when the program does not answer, you might face this issue at the next Lotus Notes start....
Read more

Scribus tutorial add hyperlink to PDF

Using Scribus free software, it is possible to add a hyperlink on top of any image, and export it to PDF format. When working on a document, would it be a vectorial document, a print poster, or simply a jpeg image, it is possible to add on top of any part of the image, a link annotation, or a hyperlink, which will be displayed in an interactive PDF as a clickable area, leading to the hyperlink opening....
Read more

MS Access MDB repair tool

Even if we will all agree to say that an Access database should certainly not exist to handle more than 2GB of data, but it can happen for some reasons that you end up with such database (Fig 1). For example, when you import external data in the database, after you deleted tables in the Access file, you still have to compact and repair it in order to clean the cache, and reduce filesize....
Read more

How to record screen on Windows 10 for free

There are several ways to record screen for free on Windows 10, either using the built in Game screen recorder accessible with Windows+G, and following the on screen instructions. The other option is to install the excellent VLC media player, and use it as a free screen video recorder for Windows 10 or any other Windows version on which it is installed....
Read more