| 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
PowerShell: Quickly Add Users into Groups on a List of Computers
$newVmNames=@( 'SERVER0001', 'SERVER0002' ) $newUsers=@( 'domain\user1' ) $groupNames='Administrators','Remote Desktop Users' $newVmNames|%{ invoke-command -computername $_ {…
Script to Rename Computers in Active Directory
1. Run this PowerShell Script to rename 1 computer: $admin = "KIMCONNECT\"+ Read-Host "Enter the…
Clean Windows C Volume
Have you ever ran into a sluggish performance on a Windows machine that is being…