Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The SORT function sorts a list alphabetically
Syntax
SORT(value1, value2, [value3], ...)
The SORT function syntax has the following arguments:
- value1 Required. A text value
- value2 Required. A text value
- value3 Optional. A text value
Example
| Formula | Description | Result |
| =SORT("e", "f", "a", "c", "d", "b") | Sort the values "e", "f", "a", "c", "d", "b" alphabetically. | a, b, c, d, e, f |
| =SORT(9, 7, 4) | Sort the values 9, 7, 4 alphabetically | 4, 7, 9 |
Errors
For a full list of formula errors, please read Formula errors.