This sort question has been asked before most likely...

**apex_predetor** · 10-17-2011, 09:10 PM

Hello All,

This sort question has been asked before most likely, but I can't seem to get it to work in my scenario?

I have about 400 rows of data that I want to sort based upon some point names. This is my problem...

When I sort a group of numbers, for instance, 1-100 it sorts 1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 2, 20....

How can I get it to sort consecutively without bumping the number two after the number 19 and before 20?

Thanks all

**MarvinP** · 10-17-2011, 09:19 PM

Hi apex_predetor and welcome to the forum,

Your rows are sorting like that because they are text instead of numbers. In a blank column put a formula of the cell plus zero. This will convert them to numbers. Copy and paste the new column over the text column and it should sort ok.

**apex_predetor** · 10-17-2011, 09:23 PM

I tried that but it goves me the #VALUE error becasue my data is alpha numeric. I was trying to simplify my "issues" in the first post.

C41
C58
DS-1
DS-10
DS-100

R-10
R-100
R-101
R-102
R-103
R-104
R-105
R-106
R-107
R-108
R-109
R-11
R-110

Here are two quick strings of data that I am trying to sort. See how it puts in the R-11 after the R-109? Can't figure it out?

Thanks for any help in advance.