Sort By Suffix?

T

Toki

New Member
Joined
Jan 9, 2008
Messages
20
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!
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Extracting variable amounts of characters from highly variable strings into two columns
Replies
7
Views
225
Peter_SSs
Peter_SSs
M
  • Question Question
How to split a full name in 1 column into 2 columns (C1 - First name, C2 - Last name (*but here's the tricky - what if there's a middle initial?
Replies
6
Views
526
Mavericx
M
R
  • Solved
Simple find & replace question
Replies
9
Views
221
Alex Blakenburg
A
B
  • Question Question
Vat calculation
Replies
1
Views
89
bimatmpmet
B
N
  • Solved
Command buttons not sorting - and sometimes jumping around on sort
2
Replies
10
Views
176
netxtown
N

Forum statistics

Threads
1,224,600
Messages
6,179,836
Members
452,947
Latest member
Gerry_F

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top