Can I sort a column of eMails according to domain (all after the ‘@’)
eg; Jim@bookman-jim.biz … sort on ‘bookman-jim.biz’
Thanks,
Jim
Create an additional column with formulas like this:
=RIGHT(A1; LEN(A1) - FIND("@";A1))
and sort by it
Another way to create an auxiliary column with the e-mail domain:
- Select the cells with e-mail addresses
- Choose menu
Data-Text to Columns… - Mark Separated by and Other, and type
@ - Select the first column heading and choose Column type:
Hide.
Beware: this will replace the e-mail addresses with the e-mail domain. Maybe you prefer to do a copy of the e-mails list and work on it.
Or:
=REGEX(A1;"(?<=@).*")
extracts the end of text after @
WOW!
How easy is that !
Thank you!
⌡im
If you would store text data in a database instead of arithmetic calculator, it would be as simple as:
SELECT *
FROM "TABLE"
ORDER BY SUBSTR("URL", LOCATE('@', "URL")+1)
This “formula” returns your entire table ordered by the domain.