ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sort in Greek alphabetical order (https://www.excelbanter.com/excel-discussion-misc-queries/212410-sort-greek-alphabetical-order.html)

jdc

Sort in Greek alphabetical order
 
Does anyone know how to sort by Greek alphabetical order? In other words,
rather than have the list "Zeta, Alpha, Gamma, Beta Tau" sorted as "Alpha,
Beta Tau, Gamma, Zeta" I'd like it to be sorted "Alpha, Gamma, Zeta, Beta
Tau" ... any ideas?

Luke M

Sort in Greek alphabetical order
 
Not very effective if this is a one-time thing, but you could create a
custom list.

Tools - Options - Custom Lists.

You basically tell Excel what order a set of words should go in, and then it
will sort by that. Its also how it knows how to sort days of the week.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jdc" wrote:

Does anyone know how to sort by Greek alphabetical order? In other words,
rather than have the list "Zeta, Alpha, Gamma, Beta Tau" sorted as "Alpha,
Beta Tau, Gamma, Zeta" I'd like it to be sorted "Alpha, Gamma, Zeta, Beta
Tau" ... any ideas?


jdc

Sort in Greek alphabetical order
 
Good thought, but I think Custom Lists only allow up to a certain number of
characters (upper 200's, as I recall). It just may not be something that can
be done!

"Luke M" wrote:

Not very effective if this is a one-time thing, but you could create a
custom list.

Tools - Options - Custom Lists.

You basically tell Excel what order a set of words should go in, and then it
will sort by that. Its also how it knows how to sort days of the week.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jdc" wrote:

Does anyone know how to sort by Greek alphabetical order? In other words,
rather than have the list "Zeta, Alpha, Gamma, Beta Tau" sorted as "Alpha,
Beta Tau, Gamma, Zeta" I'd like it to be sorted "Alpha, Gamma, Zeta, Beta
Tau" ... any ideas?



All times are GMT +1. The time now is 07:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com