I needed to sort a list of users by email domain, the trick is to make a new column and only grab everything in the email name to the right of the "@".
It's not hard but like most things, some advice on the internets is better than others.
=RIGHT(B1,LEN(B1)-FIND("@",B1))
Honestly I think I could have written the python code to do this in less time than it took me to find a decent solution in excel (10 minutes)...
Which reminds me I have to fix the scripts the generate my monthly reports. Joy!
It's not hard but like most things, some advice on the internets is better than others.
=RIGHT(B1,LEN(B1)-FIND("@",B1))
Honestly I think I could have written the python code to do this in less time than it took me to find a decent solution in excel (10 minutes)...
Which reminds me I have to fix the scripts the generate my monthly reports. Joy!
RSS Feed