![Splitting/Extracting Username and Domain name in Email address using Excel [LEFT and FIND function explained]](../../wp-content/uploads/2013/05/excel-tips-and-tricks-150x150.png)
Splitting/Extracting Username and Domain name in Email address using Excel [LEFT and FIND function explained]
A classical scenario to understand the excellence of Excel. There might be situations where we would like to split the email address in two parts i.e. the username (part at the left of @ symbol) and the domain name (part at the right of @ symbol). For example [email protected] has the username hasaanfazalpk and gmail.com is the domain name. So consider […]
Extract File Extension from file names in Excel - [Quick Tip]
What if your manager gave you a file with thousands of file names and you have to extract file extensions? If you are following our Excel tutorials on regular basis then it won’t be a problem as we have covered few of the ways that can be used to carry out this task. General knowledge […]
