excel sorting

[Adnerb]

I have a text spreadsheet of 5,000 names and addresses. Column B needs to
restricted to only 16 characters in that column. How do I send the records
to the bottom of the page (or delete them) that have data that exceeds 16
characters in Column B?

 

[tompl]

You could insert a new column. In that column, in row 2 put the formula
=len(B2) and copy it down the column. Then sort the table on then new column
ascending.

Tom