CMZTECH.NET
  • Blog
  • Graphics
  • Virtual Reality
  • 3D Printing
  • Fun Stuff
  • Contact

Sort an Excel file by Email domain...

10/29/2014

0 Comments

 
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!
0 Comments



Leave a Reply.

    David Coombes

    Making stuff

    Categories

    All
    3D Graphics
    3D Printing
    3D Scanning
    AI
    Blender
    Cycling
    Development
    Environment
    Futurism

    Archives

    January 2021
    November 2020
    May 2020
    April 2020
    March 2020
    February 2020
    December 2019
    November 2019
    September 2019
    August 2019
    July 2019
    January 2019
    December 2018
    October 2018
    August 2018
    June 2018
    April 2018
    March 2018
    February 2018
    January 2018
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    January 2017
    September 2016
    August 2016
    July 2016
    May 2016
    April 2016
    March 2016
    December 2015
    November 2015
    August 2015
    July 2015
    June 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014

    RSS Feed