Sort By Suffix?

[Toki]

Hello,

I am on a mac using 2011 and I am trying to sort one column by the suffix..

For example I am trying to sort domain names by .com - .net - .org..

I would like the .com's with each other and so on.

How can I do this with one column?

Thanks!

 

[Dryver14]

is it possible to insert another column and use the formula

say col B4 hold the address

col B5=right(B4,3)

and then sort that column

 

[Toki]

The domain are all in one column mixed. I was looking for a way to have them sort to have all the .com's together and so on.

 

[Dryver14]

yes i get that but if you can put a column next to it and use the formula it will seprate the bit you want to sort on then sort that column

 

[Ruddles]

Just thinking out loud - I haven't tried it - but could you apply conditional formatting to change the cell colour according to the suffix and then sort by colour?

 

[Toki]

Thanks Ruddles - I just applied a color for the suffix and then sorted.