Ask Your Question

Sorting by number of characters in cells in calc [closed]

asked 2013-04-06 10:36:48 +0200

jdv gravatar image

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!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-28 02:59:16.832858

1 Answer

Sort by » oldest newest most voted

answered 2013-04-06 10:54:56 +0200

oweng gravatar image

Use an extra column with the length of each string, e.g.,

A1: ""

A2: ""

B1: "=LEN(A1)" (displays "21")

B2: "=LEN(A2)" (displays "15")

Highlight both columns and sort by column B then column A.

edit flag offensive delete link more

Question Tools


Asked: 2013-04-06 10:36:48 +0200

Seen: 4,868 times

Last updated: Apr 06 '13