I want to sort some alphabetic entries to the bottom. I’m currently using the ~ character, but that sorts to the top.
Add ~ to non-alphabetic entries?
If this is a question, I don’t understand it.
How do you use ~ character?
I’ve got my answer (see above), but to reply to your question, I prefix a special character to the items I want to sort to the end.
You could prefix a special character to the items you want to sort to the start and then the items you want to sort to the end will go there automatically.
Do a test in a new spreadsheet.
· Put the formula =CHAR(ROW()), from A1 to A255
· Copy A1:A255
· Right-click and paste as text on C1
· Sort values in C
Now you can see how the characters are ordered.
Use UNICHAR() for a large list.
Looks as ‘µ’ (181) it’s always at the end.
I couldn’t quite understand the procedure you described, but I used the µ character to prefix items I wanted sorted at the end. That worked. Thanks very much.