Sort uppercase cells separately from lowercase ones
Hi!
I would like to resolve the following: I want to group cells with mixed content, numbers, lowercase and uppercase words into separate columns so I can sort them separately. Large tables, tens of thousands of cells, so it should be as automated as possible.
There are currently lowercase and uppercase words in a column, I just want to filter out the uppercase letters from them that come irregularly alternating with the lowercase letters one after the other.
Even a good sort would be a solution, for example, to separate the lowercase letters from the uppercase letters with one sort, currently I could only type them in alphabetical order, which is not yet a choice between lowercase and uppercase letters.
E.g: a <z <A <Z or A <Z <a <z sorting would be the goal instead of sorting into an alphabet that does not pay attention to the current font size.
Now I use OpenOffice Calc (7.0.4.2), but every other solutions are welcome, like online tools or in google sheets.
How could all this be solved?
Thanks in advance for your help. :)
try FINDB
in google sheets:
=INDEX(SORT({A2:A, IFNA(FINDB(REGEXEXTRACT(A2:A, "^."),
JOIN(,CHAR(ROW(50:150)))))}, 2, 1),,1)