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.
- 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.
- Okay, thanks that worked great!