| PrimaryEmail (Cell B2) | EmailUsername | Domain |
| [email protected] | =LEFT(B2,FIND("@",B2)-1) |
=RIGHT(B2,LEN(B2)-FIND("@",B2)) |
| FixedPrimaryEmail |
=IF(D2="olddomain.org",C2&"@newdomain.org",B2) |
Categories:
Related Post
Use PowerShell to Get GeoLocation of a Computer’s Public IP
Method 1: Invoke-RestMethod -Uri ('http://ipinfo.io/'+(Invoke-WebRequest -uri "http://ifconfig.me/ip").Content) Method 2: function getIPGeolocation($ipAddress) {$request = Invoke-RestMethod -Method…
PowerShell: Optimize SQL Server Memory & CPU Resources
# optimizeSqlServer.ps1 # Version 0.0.2 # This version deals with Memory, CPU # Future versions…
WinRM Issues Caused by Service Principal Name (SPN) HTTP Protocol & Port Associations
Solution as Code: There is no easy solution to this problem. Certain IIS Pool Accounts…