Sorting the list can be done via menu Data/ group Sort and filter/ Sorting. In case, if the original list is constantly introducing new values, to maintain the list in sorted condition, the user needs each time to manually sort the list via the menu, which is not always convenient. It is much easier to have dynamically controlsize list. The list consists of text values.
Generate Russian (ABVGDEJJKA...) and English (ABCDEFGHIJKLMNOPQRST...) the alphabet using the function CHAR()
Find text value when sorting the range in ascending order will appear first, i.e. the first in alphabetical order. Also find the last value alphabetically.
Determine whether the text string of letters from the Latin alphabet, numbers or UPPERCASE characters. Learn to identify the presence of unwanted characters in a single equation.
Manual translation of formulas from English to Russian is always tedious. For example, if you want to translate RIGHT(A1,LEN(A1)) RIGHT(A1,LEN(A1)). Try to automate the process.