The SORT function allows you to specify which column to sort by. You can also include a hierarchy to sort by more than one column.
Tag Archives: array syntax
Creating Full Names In Excel
When joining parts of names together, you may want vary the characters you use to separate the name. Depending on the effect you may be able to use array syntax to control the characters and their location.