Calculate MD5 and SHA1 file hashes using PowerShell V4

The majority of software distribution occurs electronically. However, the larger the downloads, the larger the risk of corrupted data transfer. Read More …

Replace Function to replace characters in a String (VBA)

Use the VBA Replace function to replace a substring of characters in a string with a new string. VBA Replace Read More …

Evaluate value between numbers (Excel)

Send Us a Sign! (Contact Us!) Show More Info This article has total words. (Including header) Generic formula =AND(val>MIN(num1,num2),val<max (num1,num2)) Read More …

Negative Number as Positive (Microsoft Excel)

With a simple custom format code, we can display negative numbers as positive…but…why would we want to? So that we Read More …

Delete custom styles in Microsoft Excel with VBA

Often times, especially when sharing files, perhaps emailing files back and forth to/from co-workers, a file can become bloated with Read More …