I would put it in a cell next to the top of the data and then copy down
for example if your data is in Cells C1 to C2000
I would insert a new column in column D and in D1 enter
=trim(clean(C1))
and copy D1 and paste to end of data in column D.


"Dennis1188" wrote:

Thanks, where do I enter this?

"bj" wrote:

There may be leading spaces or non shown characters
try in a helper column
=trim(c1)
or clean(c1)
then try to sort on this column

"Dennis1188" wrote:

I have several cells that will not sort properly. Is there some kind of
setting that will prevent them from sorting from a to z.
When I manually enter some of the problem cells again in another workbook,
they sort fine.