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)EmailUsernameDomain
[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: 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

How To Copy Folder in Legacy Windows with Long File Names?

$sourceDirectory='D:\SMBSHARE\LONGPATH' $destinationDirectory='\\FILESERVER\LONGPATH' function copyFolderWithLongNames($sourceDirectory,$destinationDirectory){ $sourceParent=split-path $sourceDirectory -parent $sourceChild=split-path $sourceDirectory -leaf $destinationParent=split-path $destinationDirectory -parent $destinationChild=split-path $destinationDirectory…
Post Image

Read More

Basic CSS: Inherit Styles from the Body Element

<style>body {background-color: black;}</style>
Other project: DragonCoin.com