Google Sheets formula to scramble words and letters.

Discussion in 'Networking and Security' started by OptionGuru, Nov 18, 2015.

  1. OptionGuru

    OptionGuru

    Is there a spreadsheet (Google Sheets) formula that will scramble words and letters using a PIN number?

    Example:
    • PIN = 4678
    • EliteTrader x 4678 = ghr4567Hre
    • ghr4567Hre x 4678 = EliteTrader


    I'm interested in putting all my usernames and passwords onto Google Sheets and would like to access the data with a PIN number.


    :)
     
    #1     Nov 18, 2015
    Share
  2. Baron

    Baron ET Founder

    Forget that OptionGuru. For password storage and management, I highly recommend 1Password
     
    #2     Nov 18, 2015
    Share
    OptionGuru and DarthSidious like this.
  3. DarthSidious

    DarthSidious

    Or LastPass for browser paswwords
     
    #3     Nov 18, 2015
    Share
    OptionGuru likes this.
  4. OptionGuru

    OptionGuru

    OK .... Thanks for the replies. I will look into 1Password and LastPass.



    :)
     
    #4     Nov 18, 2015
    Share
    lawrence-lugar likes this.
  5. sprstpd

    sprstpd

    Also take a look at KeePass. It is open source and free.
     
    #5     Nov 19, 2015
    Share