•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is there a way to change the order in which symbols are alphabetically?
Our take
Are you frustrated that Excel sorts Latvian and English words inaccurately, treating special characters like Ā and Ē as standard letters? This common issue can hinder your data organization and clarity. Fortunately, there are effective ways to customize the sorting order in your spreadsheets, allowing you to prioritize the unique characters of the Latvian alphabet. By exploring these solutions, you can enhance your data management and ensure your content reflects the correct alphabetical order.
I have a spreadsheet that has cells that consist of words both from English and Latvian. The Latvian alphabet is the same as English, but there are different letters, that are usually just versions of other letters (so for example Ā, Ē, Ģ, Ķ ect.). Whenever i try sorting the cells alphabetically excel just ignores the symbols and treats them as if they're a different letter (so for example it treats Ļ as if it was just L). Is there any way to solve this?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How do I alphabetize one column making sure the corresponding data in an another column matches the change?I want to make a copy of a spreadsheet that’s ordered by a reverse look up, it’s two interdependent columns of data but so far I can figure out how to alphabetize one and have the other column of data adjust to the change in order? submitted by /u/SluttyDreidel [link] [comments]
- Is it possible to create a custom sort order?This is more of a curiosity than a problem I HAVE to solve, so it's not essential if I don't get a solution! I have some data that I wish to sort, but rather than 1-10 or A-Z, I need it to do a specific order. Is this possible? Ai Up Ye Un No EDIT: I know that I could just put the number in front of the words, basically like I have done here and than sort numerically. It just looks a bit clunky, and also I have very narrow column for this info as I need the whole sheet to fit on the screen and be legible. submitted by /u/BoudaSmoke [link] [comments]