Sorting Problem

ar

New Member
Joined
Mar 27, 2002
Messages
24
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.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Chris Davison

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,790
**** 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

Active Member
Joined
Mar 21, 2002
Messages
379
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
 

Watch MrExcel Video

Forum statistics

Threads
1,133,243
Messages
5,657,578
Members
418,401
Latest member
B_A_M155

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top