XL.ComputeMD5Hash function: encode a text string to an MD5 hash

How to use ComputeMD5Hash function for Excel: formula and results
XL.ComputeMD5Hash function – Text function type – returns the MD5 hash value for the specified text string in a specified encoding.

Using the MD5 hashing algorithm, the function helps encode any text string into a 128-bit hash value. Supported encodings include: ASCII, Unicode, BigEndianUnicode, UTF7, UTF8, UTF32.

Before you begin, add Functions to Excel

Functions are one of the 20+ features within XLTools Add-in for Excel. Works in Excel 2019, 2016, 2013, 2010, desktop Office 365.

Get started with XLTools ribbon
Download XLTools for Excel
 – free trial gives you 14 days of full access to all features.

Syntax

=XL.ComputeMD5Hash(text, encoding)
ArgumentDescription
text
[required]		The text string to generate the hash for
encoding
[optional]		Encoding to be used to generate the hash value:
  • Default if not specified in the formula
  • ASCII
  • Unicode
  • BigEndianUnicode
  • UTF7
  • UTF8
  • UTF32

Examples [download]

Download this spreadsheet with examples and try the function yourself.

Download examples with this function (xlsx)

FormulaDescription
=XL.ComputeMD5Hash("Simple text string")Returns MD5 hash for the specified text string
=XL.ComputeMD5Hash(A3)Returns MD5 hash for the text string in cell A3
=XL.ComputeMD5Hash(A3,"ASCII")Returns MD5 hash in ASCII encoding for the text string in cell A3
=XL.ComputeMD5Hash(A3,UTF8)Returns MD5 hash in UTF8 encoding for the text string in cell A3

Any questions or suggestions?
How can we help?