View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DennisS DennisS is offline
external usenet poster
 
Posts: 2
Default How do I encode data in Excel to make it anonymous?

If you know how to write user defined functions or macros you may use VBA
logical XOR (eXclusive OR) function to encode/decode your text.
e.g.
1 XOR 3 = 2
2 XOR 3 = 1

asc("A") XOR asc("z") = 59=asc(";")
asc(";") XOR asc("z") = 65 =asc("A")

Function DoXOR(XORWhat as string, WithWhat as string) as string

The function then XORs every character from XORWhat with every character
from WithWhat (cyclically).

First Function call encodes text, second run decodes it.
Not quite elegant though.


"Aiso" wrote:

I need to change names in Excel to make it anonymous to onlookers, but make
it transferrable back to the original name for those who know the code.