adam859 Posted August 27, 2015 Posted August 27, 2015 Im having an issue sorting columns in Excel. I have a row for rooms. Example (C1,C6,C10,C12,D1,D2,D6,D12,E1,E3,E10) its sorting weird though like C1, C10,C12 then C6 How would i stop this happening.
andy_b Posted August 27, 2015 Posted August 27, 2015 You could also use two "helper" columns. One that has the just the Letter and one that just has the number and sort over these instead
howartp Posted August 27, 2015 Posted August 27, 2015 Use the left() and right() formulae in the helper columns, then you don't have to retype anything.
howartp Posted August 27, 2015 Posted August 27, 2015 =left(A1,1) =right(A1,Len(A1)-1) Where A1 is the cell with room no in.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now