XL Sort

[Bob Morrison]

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--><!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1026"/> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1"/> </o:shapelayout></xml><![endif]--> This has probably been asked a thousand times so I’ll apologise before I start.

Anyway the question is: How do you get XL to sort blank cells to the bottom, not the top?

Google has not been my friend on this one, although there are a few highly complicated methods mentioned.

XL 2002

[FONT=&quot]Thanks Bob.[/FONT]

 

[Bob Morrison]

Hmmm...It should have placed a space character into the "Find What" field, but not UNTIL you released the ALT key following the 4-key entry. If it didn't work, then I guessed incorrectly, unfortunately. Bummer!
Larry.

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--> Sorry to be a nuisance Larry but when I hold down Alt+0160 I don’t get a symbol in Word or Wordpad either, and looking up the Symbol List there doesn’t seem to be one for Alt+0160, although, Google mentions that Alt+0160 is Alt+0255 in XP and Vista.

Can you shed any light on this?

Thanks

Bob

 

[indiantrix]

Bob, No trouble, but I've not yet run across a situation where this character is not displayed. If I enter the numbers from the top row of
my keyboard, it will not work. BUT if I use the numeric keypad over on
the right side of my keyboard, while the numlock is ON and the ALT
key is depressed...then when I release the ALT key - voila! That's
about all I can say 'bout it. I was guessing that your sort problem
may have involved such a character that, although it appears to be a
space character (either leading or trailing) in the string, it cannot be
removed with a clean or trim command. Such a character is typically
generated during "data dumps" from mainframe computers.
Larry.