Sorting
Sorting
(OP)
Hi,
I'm working with electronic components that are referenced by a letter and a number(i.e. C1 C2 C3...) and I want to be able to sort these by letter then by number. Using Data>>Sort leaves me with:
C1
C11
C12
C13
C14
.
.
.
C2
C21
C22
.
.
.
Yet, I want it as C1,C2,C3....C10,C11,C12. Is there an easy way around this problem?
Thanks.
Thanks.
I'm working with electronic components that are referenced by a letter and a number(i.e. C1 C2 C3...) and I want to be able to sort these by letter then by number. Using Data>>Sort leaves me with:
C1
C11
C12
C13
C14
.
.
.
C2
C21
C22
.
.
.
Yet, I want it as C1,C2,C3....C10,C11,C12. Is there an easy way around this problem?
Thanks.
Thanks.





RE: Sorting
xnuke
"Live and act within the limit of your knowledge and keep expanding it to the limit of your life." Ayn Rand, Atlas Shrugged.
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Sorting
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Sorting