Hi,
Is there any way I can paste words backwards? I have a short list of
e-mails addresses I need to sort by: .com/.edu/.gov/.org/.net and more like
that. The easiest way I figure is to pst them all backwards in a colum of
table then just sort.
Thanks, RickB
The isn't any good way to paste backwards, but you don't have to.
The first thing is to make sure there are the same number of dots in each
address, adding extra ones at the beginning if necessary. For example, if the
starting set of addresses is
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
then you need to add one dot before john.adams and two dots before janedoe to
match the three dots in ludwig.van.beethoven:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
Once this is set up, select the whole list and click Table > Convert > Text to
Table. In the dialog, under "Separate text at", choose Other and type a dot in
the box; then click OK.
The result is a table with the last node (the "top level domain" or TLD) in the
last column. (This is the purpose of matching the numbers of dots.)
Now click Table > Sort. In the dialog, set the "Sort by" dropdown to the last
column of the table and click OK. The table will be sorted by the TLD.
Finally, click Table > Convert > Table to Text. Again choose to separate by
Other and type a dot in the box. When you click OK, the addresses will be put
back together. You'll have to run through and take out the extra dots at the
beginnings of the addresses.
