Sorting is not working properly

W

Wendy

A column with some upper case names and some lower case
names are sorting as if I've selected the case sensitive
option in the sort options box, but I haven't. I checked
the cell format and some were General and some were Text.
I've changed the entire sheet to both and still the
uppercase words stick together and the lowercase words
stick together. However, when I click in another column
that has uppercase and lowercase words it sorts them
correctly by alphabet and ignores the case. I've also
tried to copy and paste the data into a new sheet/book,
but to no avail.
Thanks in advance for any assistance.
 
W

Wendy

I solved my own problem. After looking at this for a few
minutes I realized that all of the lower case names had
leading spaces.
 
S

StarTrek an beyond

Way to go Wendy. The best lesson's in life is one's we solve a problem
ourselves. Be there done that.

Wayne B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMBO BOX vs Uppercase 6
email addresses on server are uppercase on workstation is in lower 1
Change Case in a column 2
sorting problem 3
Problem with lower case umlauts. 7
Cells are not sorting correctly 2
Data Sorting Problem 2
How can I check if a letter in a string is upper case or lower case ? 14

Top