Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort in Excel
I would I sort a row that has data and numbers but I only want to sort the
numbers? Say this is in the row: Post your question/California/5555/ I just need the number part sorted. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort in Excel
just highlight the column the number is in, then from the menu bar- data/sort
(normally that would scramble the data, but if that's what you want...) "teelee" wrote: I would I sort a row that has data and numbers but I only want to sort the numbers? Say this is in the row: Post your question/California/5555/ I just need the number part sorted. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort in Excel
No I don't want it scramble, how else would I do this?
"dlw" wrote: just highlight the column the number is in, then from the menu bar- data/sort (normally that would scramble the data, but if that's what you want...) "teelee" wrote: I would I sort a row that has data and numbers but I only want to sort the numbers? Say this is in the row: Post your question/California/5555/ I just need the number part sorted. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort in Excel
You see this is a report in excel and I have a few rows with the different
data along with numbers. I need the numbers sorted. "dlw" wrote: just highlight the column the number is in, then from the menu bar- data/sort (normally that would scramble the data, but if that's what you want...) "teelee" wrote: I would I sort a row that has data and numbers but I only want to sort the numbers? Say this is in the row: Post your question/California/5555/ I just need the number part sorted. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
Sort from SQL view does not sort in EXCEL | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |