DES Encryption functionality
I am after a function or module that I can use or import into an Excel
spreadsheet to support DES encrypt/decrypt calculations? Also, I aslo need to support XOR as well! Thanks |
DES Encryption functionality
Hi Michael,
Regarding the XOR, there is a VBA function XOR, but one appears not to have been implemented as standard in the worksheet functions. One possibility (?) if not using VBA might be to implement one as e.g. : =AND(NOT(AND(A1,B1)),OR(A1,B1)) HTH Anthony "Michael P" wrote: I am after a function or module that I can use or import into an Excel spreadsheet to support DES encrypt/decrypt calculations? Also, I aslo need to support XOR as well! Thanks |
DES Encryption functionality
Hi Michael,
Was looking around Excel. My post re XOR may not be relevant, in which case sorry for bandwidth. In Tools, Options, Security, Advanced, there is an option to choose Weak Encryption (XOR). Can't see DES as such. My guess is that there may be an Excel add-in that could be obtained. Hope that may be more helpful (?) Anthony "Michael P" wrote: I am after a function or module that I can use or import into an Excel spreadsheet to support DES encrypt/decrypt calculations? Also, I aslo need to support XOR as well! Thanks |
DES Encryption functionality
Whoa! I cant believe MS could be that loose... no arithmetic XOR
functionality... if I wanted to xor to numbers 0x48 and 0x54, how'd I do it? Any help from anyone? Raj "Anthony D" wrote: Hi Michael, Was looking around Excel. My post re XOR may not be relevant, in which case sorry for bandwidth. In Tools, Options, Security, Advanced, there is an option to choose Weak Encryption (XOR). Can't see DES as such. My guess is that there may be an Excel add-in that could be obtained. Hope that may be more helpful (?) Anthony "Michael P" wrote: I am after a function or module that I can use or import into an Excel spreadsheet to support DES encrypt/decrypt calculations? Also, I aslo need to support XOR as well! Thanks |
DES Encryption functionality
Hello,
Put '48 into A1, '54 into B1. Then =DEC2HEX(SUMPRODUCT(--(MID(HEX2BIN(A1,10),ROW(INDIRECT("1:10")),1)<MID( HEX2BIN(B1,10),ROW(INDIRECT("1:10")),1)),2^(10-ROW(INDIRECT("1:10"))))) will return your XOR. Have fun, Bernd |
All times are GMT +1. The time now is 12:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com