Case sensitive sorting in Excel

[vishnuganesh]

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

 

[Tom Ogilvy]

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.