Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort order on very large spreadsheet.
I have several cells that will not sort properly. Is there some kind of
setting that will prevent them from sorting from a to z. When I manually enter some of the problem cells again in another workbook, they sort fine. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort order on very large spreadsheet.
There may be leading spaces or non shown characters
try in a helper column =trim(c1) or clean(c1) then try to sort on this column "Dennis1188" wrote: I have several cells that will not sort properly. Is there some kind of setting that will prevent them from sorting from a to z. When I manually enter some of the problem cells again in another workbook, they sort fine. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort order on very large spreadsheet.
Thanks, where do I enter this?
"bj" wrote: There may be leading spaces or non shown characters try in a helper column =trim(c1) or clean(c1) then try to sort on this column "Dennis1188" wrote: I have several cells that will not sort properly. Is there some kind of setting that will prevent them from sorting from a to z. When I manually enter some of the problem cells again in another workbook, they sort fine. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort order on very large spreadsheet.
I would put it in a cell next to the top of the data and then copy down
for example if your data is in Cells C1 to C2000 I would insert a new column in column D and in D1 enter =trim(clean(C1)) and copy D1 and paste to end of data in column D. "Dennis1188" wrote: Thanks, where do I enter this? "bj" wrote: There may be leading spaces or non shown characters try in a helper column =trim(c1) or clean(c1) then try to sort on this column "Dennis1188" wrote: I have several cells that will not sort properly. Is there some kind of setting that will prevent them from sorting from a to z. When I manually enter some of the problem cells again in another workbook, they sort fine. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort order on very large spreadsheet.
I have found that "Sort" does not work properly when there are "nonbreaking"
spaces (you cannot see them in Excel) in your spreadsheet. To get convert them to regular spaces as follows: CTRL+H {shortcut for EDIT REPLACE} Find what: {enter "Alt+0160" --without the quotes, using NUMPAD numbers} Replace with: {enter one regular space here} Click on REPLACE ALL Do you want to replace the rest of the document? NO OK "Dennis1188" wrote: I have several cells that will not sort properly. Is there some kind of setting that will prevent them from sorting from a to z. When I manually enter some of the problem cells again in another workbook, they sort fine. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I set up a excel spreadsheet to auto sort data in order | Excel Discussion (Misc queries) | |||
Sort a large file then sum like values... | Excel Discussion (Misc queries) | |||
Sort order for chart only and not on spreadsheet | Charts and Charting in Excel | |||
Sort order for graph only and not spreadsheet | Excel Discussion (Misc queries) | |||
How to sort/update large excel db | Excel Discussion (Misc queries) |