Showing posts with label cer. Show all posts
Showing posts with label cer. Show all posts

Sunday, December 4, 2022

Convert a putty .ppk key to an Amazon .pem file on Mac

$ brew install putty

$ puttygen key.ppk -O private-openssh -o key.pem

Or,

$ openssl x509 -in certificatename.cer -outform PEM -out certificatename.pem

Extract Domain from email in Excel or Google sheet

  =TEXTAFTER( A2 , "@") or, =MID(A1, FIND("@", A1) + 1, LEN(A1) - FIND("@", A1))