I have a list of domains, they are all different in length. How can I sort by the number of characters in the cell? Thanks!
Use an extra column with the length of each string, e.g.,
A1: “biglongdomainname.com”
A2: “shortdomain.com”
B1: “=LEN(A1)” (displays “21”)
B2: “=LEN(A2)” (displays “15”)
Highlight both columns and sort by column B then column A.