Sorting data

M

mrdb

I download a list of a thousand or so items. The items in column 1. are
xxxxxx.com, xxxxx.us, xxxx..net, etc.

I would like to be able to sort out all entries according to the .com,
us. or .net, etc.

Thanks in advance,

Bill
 
D

Dave Peterson

If the data looks like xxxxx.yyy and there's always exactly one dot, then maybe
you could use Data|Text to columns. Specify delimited and separated by a
period.

But insert an adjacent column next to your data first. Then you could skip the
first field and place the second field in that adjacent column when you're
following that wizard.
 
Top