Excel help - difficulty [hard] lol
Discussion
Hi all. I need to be able to convert a cell into SHA256 value.
Anyone know where to start?
This page seems to have the script, but I think it's more complicated than it needs to be.......is there an easier option?
https://codedocu.com/Office-365/Excel/Templates/Ex...
Thanks all.
Anyone know where to start?
This page seems to have the script, but I think it's more complicated than it needs to be.......is there an easier option?
https://codedocu.com/Office-365/Excel/Templates/Ex...
Thanks all.
Edited by audi321 on Tuesday 20th December 18:37
From ChatGPT, no idea if correct:
You can use the following formula in Excel to compute the SHA-256 hash of a string:
=HASHBYTES("SHA2_256", [string])
For example, to compute the SHA-256 hash of the string "Hello, world!", you would use the following formula:
=HASHBYTES("SHA2_256", "Hello, world!")
This will return the hash as a hexadecimal string.
Keep in mind that the HASHBYTES function is only available in Excel 2016 and later versions. If you are using an earlier version of Excel, you will need to use a different method to compute the SHA-256 hash.
You can use the following formula in Excel to compute the SHA-256 hash of a string:
=HASHBYTES("SHA2_256", [string])
For example, to compute the SHA-256 hash of the string "Hello, world!", you would use the following formula:
=HASHBYTES("SHA2_256", "Hello, world!")
This will return the hash as a hexadecimal string.
Keep in mind that the HASHBYTES function is only available in Excel 2016 and later versions. If you are using an earlier version of Excel, you will need to use a different method to compute the SHA-256 hash.
Thanks for the Hashbytes command but I simply cannot get this to work (I have >2016 version).
However, it looks like I have a solution now. I've finally found an online encoder which can do batch encoding on different lines (99% of them just treat different lines as the same string).
https://www.miraclesalad.com/webtools/sha256.php
I'll just upload the string to encode and then paste it back into the excel document.
Thanks all.
However, it looks like I have a solution now. I've finally found an online encoder which can do batch encoding on different lines (99% of them just treat different lines as the same string).
https://www.miraclesalad.com/webtools/sha256.php
I'll just upload the string to encode and then paste it back into the excel document.
Thanks all.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff