I have a spread sheet w/ colB = E-mails.
I can FIND .org and copy each (10,000), but would rather SORT on '.org' (at the end of the e-mail address) and copy the top bunch.
Any ideas would be helpful.
TNX in advance ⌡im [THE BookMan]
[Solved] How to SORT on '.org' at end of address
-
- Posts: 107
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area
[Solved] How to SORT on '.org' at end of address
Last edited by Hagar Delest on Sun May 20, 2018 11:09 am, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
Open Office 4.1.3 Win 10
Re: How to SORT on '.org' at end of address
Use a helper column. Assuming aaa.org is in A1, use the formula
=right(A1;3) in another column to "pick off" the extensions and sort on the extensions.
This assumes all extensions are three characters in length.
=right(A1;3) in another column to "pick off" the extensions and sort on the extensions.
This assumes all extensions are three characters in length.
LibreOffice 7.3.7. 2; Ubuntu 22.04
-
- Posts: 107
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area
Re: How to SORT on '.org' at end of address
Alternative codes, that will allow for extensions that are of varying lengths, can be found at viewtopic.php?f=9&t=74250
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.