Excel function for MD5 hashing without VBA

When capturing¬†PII data (Personally identifiable information) in GA or Adobe analytics, you need to make sure that the values captured are encrypted/hashed to respect¬†the rules of these platforms. Otherwise you might have your account deactivated without any prior notice! A very common hashing algorithm is MD5. It produces a 128-bit hash value and it’s a one-way hashing algorithm, meaning that you cannot convert the hashed value back to the original one. To be able to compare and correlated hashed values with offline data you need to also hash (using the same algorithm) the key value of your 2 data sets...