How can I sort mostly 3 decimal with some 4 decimal numbers

Maybe I didn't explain it properly. I have about 300 computers that have
mostly 3 number designations, something like tnc314 and then I have 100 of
them that have numbers like tnc3148. Now when I sort, the 3 and 4 number
computer names are all bunched together. How can I have the 3 number names
sorted by itself, and then the 4 number ones on the end. All in sequence of
course. Your help is very much appreciated......Peter

Insert a new column.
put a formula like:
=len(a1)
that'll return 6 or 7.

and drag down the column

Sort your data using this as the primary key and the id's as the secondary key.

PeterM wrote:
>
> Maybe I didn't explain it properly. I have about 300 computers that have
> mostly 3 number designations, something like tnc314 and then I have 100 of
> them that have numbers like tnc3148. Now when I sort, the 3 and 4 number
> computer names are all bunched together. How can I have the 3 number names
> sorted by itself, and then the 4 number ones on the end. All in sequence of
> course. Your help is very much appreciated......Peter

--

Dave Peterson

Many thanks Dave, I will try it in a couple of hrs, after our
meeting......Peter

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44E1FC3A.1612A23@verizonXSPAM.net...
> Insert a new column.
> put a formula like:
> =len(a1)
> that'll return 6 or 7.
>
> and drag down the column
>
> Sort your data using this as the primary key and the id's as the secondary
> key.
>
> PeterM wrote:
>>
>> Maybe I didn't explain it properly. I have about 300 computers that have
>> mostly 3 number designations, something like tnc314 and then I have 100
>> of
>> them that have numbers like tnc3148. Now when I sort, the 3 and 4 number
>> computer names are all bunched together. How can I have the 3 number
>> names
>> sorted by itself, and then the 4 number ones on the end. All in sequence
>> of
>> course. Your help is very much appreciated......Peter
>
> --
>
> Dave Peterson

WOW Dave, that was awesome help......It worked swell. I appreciate you a
lot..............Peter

"PeterM" <pmaston@comcast.net> wrote in message
news:ObYhHyIwGHA.4612@TK2MSFTNGP02.phx.gbl...
> Many thanks Dave, I will try it in a couple of hrs, after our
> meeting......Peter
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:44E1FC3A.1612A23@verizonXSPAM.net...
>> Insert a new column.
>> put a formula like:
>> =len(a1)
>> that'll return 6 or 7.
>>
>> and drag down the column
>>
>> Sort your data using this as the primary key and the id's as the
>> secondary key.
>>
>> PeterM wrote:
>>>
>>> Maybe I didn't explain it properly. I have about 300 computers that have
>>> mostly 3 number designations, something like tnc314 and then I have 100
>>> of
>>> them that have numbers like tnc3148. Now when I sort, the 3 and 4 number
>>> computer names are all bunched together. How can I have the 3 number
>>> names
>>> sorted by itself, and then the 4 number ones on the end. All in sequence
>>> of
>>> course. Your help is very much appreciated......Peter
>>
>> --
>>
>> Dave Peterson
>
>

Glad it worked ok.



PeterM wrote:
>
> WOW Dave, that was awesome help......It worked swell. I appreciate you a
> lot..............Peter
>
> "PeterM" <pmaston@comcast.net> wrote in message
> news:ObYhHyIwGHA.4612@TK2MSFTNGP02.phx.gbl...
> > Many thanks Dave, I will try it in a couple of hrs, after our
> > meeting......Peter
> >
> > "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> > news:44E1FC3A.1612A23@verizonXSPAM.net...
> >> Insert a new column.
> >> put a formula like:
> >> =len(a1)
> >> that'll return 6 or 7.
> >>
> >> and drag down the column
> >>
> >> Sort your data using this as the primary key and the id's as the
> >> secondary key.
> >>
> >> PeterM wrote:
> >>>
> >>> Maybe I didn't explain it properly. I have about 300 computers that have
> >>> mostly 3 number designations, something like tnc314 and then I have 100
> >>> of
> >>> them that have numbers like tnc3148. Now when I sort, the 3 and 4 number
> >>> computer names are all bunched together. How can I have the 3 number
> >>> names
> >>> sorted by itself, and then the 4 number ones on the end. All in sequence
> >>> of
> >>> course. Your help is very much appreciated......Peter
> >>
> >> --
> >>
> >> Dave Peterson
> >
> >

--

Dave Peterson