Powershell – Variable for Null, Empty String and White Space

More often than not, we create variables with the intent they will hold a value. We typically then choose to act upon that value. Therefore, if a variable doesn’t have value, this is something we would want to check against in our conditional logic flow. Read More …

Excel – Remove Everything But Duplicate Rows

In Excel, we all know that, there will be a moment in which we need the opposite the people usually need on usual Excel worksheets: this is the case of searching and filtering, from a dataset, only duplicates values, removing the unique ones. Read More …

Excel – Formula to check if cell contains specific string

=ISNUMBER(SEARCH(substring,text)) If you need to check if a cell contains a substring (specific text), you can do so with the Read More …

If Acronis True Image 2015 does not recognize your SSD…

Sometimes Acronis True Image 2015 may not recognize an SSD. In such a case, check whether the SSD is recognized Read More …

Determine which versions and SP levels of Microsoft .NET Framework are installed

Use the registry information below to determine which version(s) and service pack level(s) of the Microsoft .NET Framework are installed. Read More …