In Libre Office “Calc”, is it possible to sort spreadsheet rows into alphabetical order, based on the first letter in the first cell of each row ?
Please find attached PDF snip of the type of spreadsheet I’m working on ?
Many thanks, Mike
Help query for LibreOPffice Calc.pdf (92.4 KB)
Please don’t attach pdf files or insert views in such a case. The reasonable attachment to questions about calc is a .ods example in next to every case.
Sorting alphabetically using the UI tools is of course supported. If you actually want to sort only by the first letter, (“Az” before “Aa”; why??) you can use a helper colum with formulas returning the first letter of the cells in the column to sort by.
If working with LibO V24.8 or higher you can also use the SORTBY() function with adapted argument expressions - depending on the circumstances.