At 17:29 20/06/2019 -0400, Daniel Noname wrote:
Is there a way to remove duplicates from a mail list using a TextEdit ...
A what?
... with OpenOffice on a Mac Computer?
Yes.
o Open a new spreadsheet (Calc) document.
o Paste your list into a column.
o Select the range containing the list (or just the entire column).
o Go to Data | Filter > | Standard Filter... .
o For the first "Field name", select "- none -" from the drop-down menu.
o Click More Options.
o Ensure that "Range contains column labels" is not ticked (unless
you have included a column label).
o Tick "No duplication".
o Click OK. Duplicate entries are now hidden.
o Select the (reduced) range.
o Copy the range (Edit | Copy or Ctrl+C). Crucially, entries hidden
using a filter are omitted from the copy action.
o Paste the edited list back into your source.
Remember that small and perhaps insignificant differences between
entries - different cases, spacing, punctuation - will prevent
otherwise similar entries being identified as duplicates.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
