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

PrimaryEmail (Cell B2) EmailUsername Domain
test@olddomain.org =LEFT(B2,FIND("@",B2)-1) =RIGHT(B2,LEN(B2)-FIND("@",B2))
FixedPrimaryEmail
=IF(D2="olddomain.org",C2&"@newdomain.org",B2)

Leave a Reply

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