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 2024, 2019, 2016, 2013, 2010, and Microsoft 365.

Download XLTools for Excel

– free trial gives you 14 days of full access to all features.

Syntax

=XL.ComputeMD5Hash(text, encoding)

Argument	Description
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, ASCII, Unicode, BigEndianUnicode, UTF7, UTF8, UTF32

Examples [download]

Download this spreadsheet with examples and try the function yourself.

Download examples with this function (xlsx)

Formula	Description
`=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

Explore other functions

Any questions or suggestions?

How can we help?