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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top