Case sensitive sorting in Excel

  • Thread starter Thread starter vishnuganesh
  • Start date Start date
V

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
 
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.
 
Back
Top