Forum Discussion
Solved
Excel custom aphlabetical sort not working properly
I'm trying to sort a big list of names first by last name, then by first name. I'm finding that some of the sort is not accurate. I colored the cells only for easier viewing of the inaccurate sort....
The attached workbook is a re-creation of the sort issue you have in your workbook. There's also a LEN example.
There may be leading or trailing spaces in the First Name and/or Last Name columns.
- Patrick2788 we checked for spaces & made sure nothing was "hidden"
- I've never used LEN() Can you explain more?
The attached workbook is a re-creation of the sort issue you have in your workbook. There's also a LEN example.
