« ToDo List Template to Download | Extract Sheet Name to a Cell (No VBA) » |
Jul
17
Hi there,
Do you know how to extract username and domain name separately from the cell contains email ID? If you know, share it using our comments to know how you work on this challenge.
Here, let us take my email ID
and the output should be like NOURGENT in a one cell and the other cell should contain YAHOO.COM.
To do this, I have two methods.
...
1. Using Formulas
2. TEXT to COLUMNS
Download working file .xls from here
Last But Not The Least - Here is your homework
How to extract GOLD from GOLDMINE? (use formulas)
DO YOU USE ANY OF THEM?
You can start sharing your ideas, suggestions & comments using below space in the comments section. If you find this helpful, please do share it on your social networking sites by clicking on the icons placed around the blog. If you want to support me for maintaining this blog, REGISTER here for free. Yes, Its absolutely free. You can also receive monthly NewsLetters too.
SOME IMPORTANT LINKS:
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments