Sorting Problem

[ar]

I received a worksheet with a column showing Accounting Period (AP 01-01, AP 02-02, etc.). The Accounting Period are not sorted together so I click the "Sort Ascending" toolbar button but it will show some AP-01 down the column and then some AP-02-02, AP-03-02, etc and then back to AP 01-01. I tried formatting the column heading by "General", "Number" and "Text", and I still get the same problem.

 

[Chris Davison]

**** accountants....

I suppose you could use "replace" if it's a temporary, one-off thing

replace "AP-" with "AP " * on the whole column

*(that's "AP space")



_________________
Hope this helps,
Chris

[Excel '97; Windows ME]
This message was edited by Chris Davison on 2002-09-06 11:54

 

[dtaylor]

if the data is all the same number of characters you could use the right formula

insert a blank column
=right(a1,4)

a1 = column with data
4 = number of spaces from the right.

and then sort the file by this column, once sorted you can delete or hide the column for future use.
if your data is not all the same character size you will need to incorp the len function.

hope this helps!

dan