excel sorting

[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

 

[Anders S]

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

 

[cnash]

Worked! Thanks

 

[Anders S]

You're welcome. Thanks for the feedback.

Anders Silven