Not sure if this is the right place for this, but I think it's fine.

I am trying to sort a column with data labeled, "ss1,ss2....ss500" but when i sort it I get "ss1,ss10,ss100,ss101,ss102, etc...."

Is there a way to custom sort it like this? If so how?

25fg for a working solution that I can follow.

1 comes before 10 comes before 100. What is the actual problem?

create a new column with just the number, then sort by that column

However 2,3,4,5,6,7,8,9 come before 10, but not when i sort.

My data comes in scrambled, so making a new column to keep track of the current sort doesn't help.

define "scrambled"? I was referring to splitting the column via substring if you know it is prefixed in ss, or any string for that matter.

Well i have two columns, one with the "real label", one with "my label". My label is the SS#. The data is already written in my excel file sorted by the "real label" so the SS#s are scattered throughout the spreadsheet in no order.

Is there a quick way to split one cell containing ss300 into two cells containing ss and 300? If so, that is a decent solution. Keep in mind, I cannot do anything manually cell by cell, there are over 5000 rows.

Read my post that you just quoted. It has the answer.

Thanks, got it using =MID(cell, 3, 4).