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

Basic CSS: Use an id Attribute to Style an Element

<link href="https://fonts.googleapis.com/css?family=Lobster" rel="stylesheet" type="text/css"><style>.red-text {color: red;}h2 {font-family: Lobster, monospace;}p {font-size: 16px;font-family: monospace;}.thick-green-border {border-color: green;border-width: 10px;border-style:…
Post Image

Read More

PowerShell: Synchronize Files Between Different Domains

<# File_Copy_Script_UNC_to_Local_V0.1.ps1Purpose: connect to an external domain to copy files onto a Intranet server.Features:- Synchronize…
Post Image

Read More

Apache Multiple Domains Config

vim /ect/httpd/conf/httpd.conf <VirtualHost *:80>      ServerAdmin [email protected]      ServerName kimconnect.com      ServerAlias www.kimconnect.com      DocumentRoot…