Excel Substitute Formula with examples

Problem:

In column A I have a list of email addresses, I want to put these into column B but in the same cell I want to add another line with a new email address – based on everything before the domain of old email address.

So basically I want to substitute everything with the original text string with my new text string.

Continue reading “Excel Substitute Formula with examples”

Deploying Windows 10 to AWS using Packer and the AWS PowerShell module

Setup an AWS SES Bounce dashboard monitor with daily email reports-logo

The reason for this post is that I wanted to create a one click solution to deploy a Window 10 machine into AWS.  I wanted the AWS instance to be named in Windows, added to the domain, install applications, name the AWS instance tag an much more.  The tools I initially decided on to create this were VMware, awscli, PowerShell, Terraform and Packer.

Continue reading “Deploying Windows 10 to AWS using Packer and the AWS PowerShell module”