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
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)
"Daniel" <nospam@nowhere> wrote in message
news:%[email protected]...
> 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
>
Great
thanks for your help
Daniel
"Peo Sjoblom" <[email protected]> wrote in message
news:OISx3%[email protected]...
> 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)
>
>
>
> "Daniel" <nospam@nowhere> wrote in message
> news:%[email protected]...
>> 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
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks