Sorting name lists alphabetically

Copper Contributor

How do I sort a list of names from random order into alphabetical order?

2 Replies

@JimLogan76c 

 

Hi, assuming your list ranges in A1:A50, try this on B1:

 

=SORT(A1:A50,,1)

@JimLogan76c 

on ribbon Data->Sort