Hashing in Excel

Hi all,

I was wondering if there's a way to perform hashes in excel 2011 (MAC), specifically MD4, MD5, and sha256?

All the threads I found on the subject were from 2011, locked, or had outdated links and information.

Thanks in advance for your help!

Originally Posted by MrShorty

I put "hashing in Excel" into my favroite internet search engine and found many workable links and discussions. This one might be of particular interest: http://web.archive.org/web/200805260...eecode.htm#md5

Thanks a ton. I'll go through this

Update:

I downloaded files from the link you gave, and there's code present in the HTML files which I believe is VB. I tried copy-pasting the code (No VB experience, I'm afraid ) and couldn't get it to work. I tried defining it as a macro as well but to no avail.

The particular files in question were the 'sha256 digest' and 'MD5 digest' zips.

It's the aforementioned hashes in particular that I need, sorry.

Thanks, Kyle. I have imported the files as such:

Screen Shot 2015-11-18 at 13.49.03.png

How would I go about having one column of strings populate a separate column with a hash of those values?

Thanks again

Please upload a sample workbook

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Morning, here's a sample workbook.

HashingExample.xls

I'm trying to set up things so that the input column automatically generates the MD4, MD5, and Sha256 hashes into 3 other columns. I have imported the class files across but I'm unsure what to do with them. As of this point I've yet to locate a MD4 .cls file. Once I understand how the other two are used I should be fine and can set out looking for one.

Thanks in advance.

You haven't imported them properly, delete everything above the green comment text. So the top of each class looks like this (obviously different for the SHA version):

'*******************************************************************************
' MODULE:       CMD5
' FILENAME:     C:\My Code\vb\md5\CMD5.cls
' AUTHOR:       Phil Fresle
' CREATED:      16-Feb-2001
' COPYRIGHT:    Copyright 2001 Frez Systems Limited. All Rights Reserved.
'

Then in a standard module:

Public Function MD5(s As String) As String

    Static md5Hash As CMD5
    If md5Hash Is Nothing Then Set md5Hash = New CMD5
    
    MD5 = md5Hash.MD5(s)
    
End Function
Public Function SHA256(s As String) As String

    Static sha256Hash As CSHA256
    If sha256Hash Is Nothing Then Set sha256Hash = New CSHA256
    
    SHA256 = sha256Hash.SHA256(s)
    
End Function

Then in D4:

=SHA256(B4)

I4:

=MD5(B4)

Okay, I've done that, I think. I removed the text above the screen content and both class files start as you specified.

The functions show up in predictive text for cells, but the algorithm simply returns #REF! though.

HashingExample.xls

It must be something with your computer, your workbook works fine for me. Your formulas looked weird, they showed as:

=#Ref(B4)

But once I'd changed them to the correct names, everything works as expected

I'm inputting the correct names but they return #REF!. If I exit and reopen the workbook the inputs change to #REF! as well. I've tried saving it as .xlsm but there's been no change to this issue

Does it work on a windows version?