#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default 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   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating workbook with an alpha sort sheet and a numeric sort shee cjlatta Excel Discussion (Misc queries) 2 January 28th 09 12:00 AM
sort function for dates does not sort properly in Office 2007 Exc. Rosalie Excel Worksheet Functions 1 November 22nd 07 10:25 PM
Sort from SQL view does not sort in EXCEL Pat M - City of Reno Excel Discussion (Misc queries) 0 August 31st 07 07:38 PM
Excel sort by Fill Color by custom list sort Dash4Cash Excel Discussion (Misc queries) 2 July 29th 05 10:45 PM
Excel Sort function should not sort the cell formatting! Lisa D.N.1 Excel Worksheet Functions 1 December 28th 04 08:37 PM


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"