Sorting data

  • Thread starter Thread starter mrdb
  • Start date Start date
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
 
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.
 
Back
Top