Posted On June 25, 2019

Excel Challenge: Update Records with a New Email Domain if It Matches Deprecated Domain

kimconnect 0 comments
blog.KimConnect.com >> Codes >> Excel Challenge: Update Records with a New Email Domain if It Matches Deprecated Domain
June 25, 2019June 25, 2019 kimconnectkimconnect 0 Comments
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:

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

Post Image

Read More

PowerShell: Disable Forticlient Web Filtering

# disableForticlientWebfiltering.ps1 # Note: untested script - use as sample as this snippet is incomplete…
Post Image

Read More

NaN

- Meaning: Not a Number - When used as an assignment to an element index…
Post Image

Read More

PowerShell: Set PasswordNeverExpires on SamAccountName

Quick 1-liner Code $accounts=@( 'orange', 'apple', 'pear', 'dog', 'cat', 'dinosaur', 'chicken', 'cow', 'yomama', 'yodada' )…