excel sorting

  • Thread starter Thread starter cnash
  • Start date Start date
C

cnash

I am trying to sort data from our database that has client names in al
uppercase, and all company names with the first character uppercase an
the rest lowercase.

ie.

JOHN STEVENS
Apple Tree Studio

I'd like to sort the sheet with the companies first alphabetically the
the client names alphabetically. How can I do this
 
One way is to use a helper column.
Assuming the names are in column A starting in A2, insert a new column B and
enter in B2

=-EXACT(A2,UPPER(A2))

and fill down.

The sort on columns B and A.

HTH
Anders Silven
 
Back
Top