Excel & AutoHotkey-Replacing Null values in Excel

Replacing Null values in ExcelWhen some programs export data they will insert #Null! into a cell to indicate there was no data (SPSS to name one).  While I would rather have something than nothing, when trying to compute averages or share data with clients the #Null! value is not ideal.  🙁  In this tutorial I demonstrate how easy it is to Replacing Null values in Excel with AutoHotkey.

The following video demonstrates Replacing Null values in Excel.  While I didn’t show the entire code in the video, it is below for your reference.

Excel & AutoHotkey-Replace Null / Missing values

 

AutoHotkey Function for Replacing Null values in Excel