sorting by text

  • Thread starter Thread starter rneedham
  • Start date Start date
R

rneedham

I have a list of domain names. from .com .net .org etc etc.
they are scattered throughout the the list and i want to organize them.
any help on this.?

ryan
 
You might do Data > Text to columns on the list and seggregate the elements
of the "names" into separate columns. Then it would be a simple matter to
group them by .com, .net, etc.........with multi-key sorts.

hth
Vaya con Dios,
Chuck, CABGx3
 
how do i seggregate the elements of the names. I found "text to columns
and ive created my own customized sort but i don't know what else t
do
 
When you use text to columns,
choose delimited,
next,
choose other,
add the period,
next,
finish.

You now have 2 columns, with the dot domains in the second column.
Multi-Sort, first on the domains, then on the first column.

Now, in the third column (column C, assuming A,B, and C were used), enter
this formula:

=A1&"."&B1

And drag down to copy.

You can now delete column A and B if you wish.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


how do i seggregate the elements of the names. I found "text to columns"
and ive created my own customized sort but i don't know what else to
do.
 
You could do a Data > text to columns, with the dot as the delimiter and
separate the names into parts and then it would be easy to sort on any
columns.........then you could concatenate the names back together again if
you wish at the end.........

Vaya con Dios,
Chuck, CABGx3
 
You could do a Data > text to columns, with the dot as the delimiter and
separate the names into parts and then it would be easy to sort on any
columns.........then you could concatenate the names back together again if
you wish at the end.........

Vaya con Dios,
Chuck, CABGx3
 
You could do a Data > text to columns, with the dot as the delimiter and
separate the names into parts and then it would be easy to sort on any
columns.........then you could concatenate the names back together again if
you wish at the end.........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top