Use this handy tool to sort your data by the length of each entry. Paste data directly from excel or other tab delimited text data and choose which field you want to sort by. The data will automatically be sorted based on the length of the field you chose in each record. If the data set is too large, or you prefer to do it yourself in Excel, you can use a "helper column" and insert the formula like this =LEN(A1) where A1 is the field you wish to sort by character count. Use double click on the fill + tool to fill all the way down.