Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |