Sorting numerically

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hi

I have a column with a list C1 to C2000,
it is jumbled up, I want to sort it numerically from
C1,
C2 etc
but when I sort the column it puts C1001 before C123, is there some way I
can stop this.

thanks

Daniel
 
You need to use a help column since the data is text, if indeed the data
starts with C then the numbers you can use

=--REPLACE(A3,1,1,"")

then sort on the help column ascending



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Great

thanks for your help

Daniel
Peo Sjoblom said:
You need to use a help column since the data is text, if indeed the data
starts with C then the numbers you can use

=--REPLACE(A3,1,1,"")

then sort on the help column ascending



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
Click to expand...
 
Back
Top