Case sensitive sorting in Excel
 

In Excel, while doing case sensitive sorting, it sorts all the A's
first, then all the B's, then all the C's.......But, I need all the
capital A's to sort fiirst followed by all small a's to sort.

Please help me


---
Message posted from http://www.ExcelForum.com/

Case sensitive sorting in Excel
 

You would need to create a dummy column with a formula to establish the sort
order you want. There is not built in option to do this.

--
Regards,
Tom Ogilvy

"vishnuganesh " wrote in
message ...
In Excel, while doing case sensitive sorting, it sorts all the A's
first, then all the B's, then all the C's.......But, I need all the
capital A's to sort fiirst followed by all small a's to sort.

Please help me


---
Message posted from http://www.ExcelForum.com/