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) |
Random Notes from a Computer IT Worker
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) |