Get Domain Name from email Address | RIGHT, LEN, FIND Function
Learn more:- https://exceltutorial.net/domain-from-email-address/
=============================================================
Previously In this Channel;
Add Row Index In Power Query:- https://youtu.be/jbZTdpg7ZZc
Month Name and Number :- https://www.youtube.com/watch?v=WJexkRPo-SY
COUNTIF:- https://www.youtube.com/watch?v=gpYCgLqciuA
Rounddown:- https://www.youtube.com/watch?v=U13Ounbk4Jg
COUNT FUNCTIONS:- https://www.youtube.com/watch?v=NBPgxlFqg1E
=============================================================
Domain Name from Email Address
=============================================================
Here to extract domain name from email address we will use three function i.e.
RIGHT Function
LEN Function
FIND Function
Workflow :- = RIGHT(“cell number”, LEN(cell number) – FIND(“@”,cell number))
The find text will be our @ sign as we our looking for what’s on the right side of the same. But do not forget to write the same quotation marks.
Follow this video for complete process.
=============================================================
Comments are closed.