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

How To Hide Featured Image in Blog Posts in Single View

In WordPress, single posts can have a featured image to help with displaying in List…
Post Image

Read More

PowerShell: Connecting via WinRM with a Timeout

$credentials=get-credential $sessionTimeout=New-PSSessionOption -OpenTimeout 120000 # 2 minutes $sessionIncludePort=New-PSSessionOption -IncludePortInSPN -OpenTimeout 120000 $session=if($credentials){ try{ New-PSSession -ComputerName…
Post Image

Read More

PowerShell: Validate SQL Server Credentials

Add this to your SQL toolbox so that it'll be quick and easy to validate…