Ask Your Question
0

What special character can I use to force alphabetic entries to sort to the end? [closed]

asked 2016-06-09 23:04:00 +0200

LOnewuser gravatar image

I want to sort some alphabetic entries to the bottom. I'm currently using the ~ character, but that sorts to the top.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by LOnewuser
close date 2016-06-11 21:18:41.257671

2 Answers

Sort by » oldest newest most voted
0

answered 2016-06-10 10:42:27 +0200

Stephanium Lupis gravatar image

Add ~ to non-alphabetic entries?

edit flag offensive delete link more

Comments

If this is a question, I don't understand it.

LOnewuser gravatar imageLOnewuser ( 2016-06-10 12:55:56 +0200 )edit

How do you use ~ character?

Stephanium Lupis gravatar imageStephanium Lupis ( 2016-06-10 14:32:41 +0200 )edit

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.

LOnewuser gravatar imageLOnewuser ( 2016-06-11 21:20:00 +0200 )edit

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.

Stephanium Lupis gravatar imageStephanium Lupis ( 2016-06-12 11:46:32 +0200 )edit
0

answered 2016-06-11 00:13:10 +0200

m.a.riosv gravatar image

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.

edit flag offensive delete link more

Comments

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.

LOnewuser gravatar imageLOnewuser ( 2016-06-11 21:17:13 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2016-06-09 23:04:00 +0200

Seen: 58 times

Last updated: Jun 11 '16