| 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: Obtain Computer Account Parent Container from Invoke-Command
# ObtainComputerAccountParentContainer.ps1# This is a demonstration of how to pass function into an invoke-command as…
PowerShell: Add Local Group Members Onto a Server List
Sometimes, the GUI method of accomplishing tasks is too arduous and error prone. Thus, these…
match
- The match() method retrieves the matches when matching a string against a regular expression.…