# Sorting text - uppercase always coming before lowercase

**URL:** <https://community.easymorph.com/t/sorting-text-uppercase-always-coming-before-lowercase/2109>\
**Category:** General Q&A\
**Created:** [September 9, 2020, 9:02am UTC](https://community.easymorph.com/t/sorting-text-uppercase-always-coming-before-lowercase/2109 "2020-09-09T09:02:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![roberto](https://community.easymorph.com/user_avatar/community.easymorph.com/roberto/32/8595_2.png) [@roberto](https://community.easymorph.com/u/roberto)\
**Post date:** [September 9, 2020, 9:02am UTC](https://community.easymorph.com/t/sorting-text-uppercase-always-coming-before-lowercase/2109/1 "2020-09-09T09:02:21Z")

</div>

Hello,

When sorting a column with text values, the uppercase letters are sorted before the lowercase letters. Is there a way to sort (without having to change the case of the values) where that the case does not have any impact, so the sorting is based purely on the actual value?

In the following example, "Acabado" appears after "ACUMULADOR", but if we take into account only the value and not the case, it should be sorted before:

 ![image](https://community.easymorph.com/uploads/default/original/2X/c/c9f1ceab046ded66cb6c206c0f2c083cf2102a8b.png)

Thanks very much,

Roberto

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [September 9, 2020, 6:15pm UTC](https://community.easymorph.com/t/sorting-text-uppercase-always-coming-before-lowercase/2109/2 "2020-09-09T18:15:06Z")

</div>

How about creating a separate column with lowercase values and use it for sorting?

---

<div class="post-metadata">

**Author:** ![roberto](https://community.easymorph.com/user_avatar/community.easymorph.com/roberto/32/8595_2.png) [@roberto](https://community.easymorph.com/u/roberto)\
**Post date:** [September 11, 2020, 10:45am UTC](https://community.easymorph.com/t/sorting-text-uppercase-always-coming-before-lowercase/2109/3 "2020-09-11T10:45:12Z")

</div>

Hello Dmitry,

Yes that works, I see that it also happens with accent marks ("a" is ordered before "á"), so apart from making it lowercase, I will also replace all letters with accent marks to their equivalent without accent marks in the expression.

Excel orders text values in a different manner, it doesn't take into account differences in upper/lowercase or accent marks.

Thanks!

Roberto
