Data Sorting Problem

[Dado]

Hello,

In case of sorting large data alphabetically, once I do sorting function of
data by name in column A it creates two sorted lists, for example 100 names,
it sorts 20 from A to Z and than remaining 80 names AGAIN from A to Z. I
can’t get it sort the entire document in one list. Please help and thank you
in advance!!

 

[Sean Timmons]

Sounds like perhaps some of the data has a space in front of it. Either that
or you may have a blank row in between... if the second, just highlight the
whole workbook and sort..

 

[Janet]

Could it be that some are in uppercase and some in lowercase?