excel sorting

  • Thread starter Thread starter Adnerb
  • Start date Start date
A

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?
 
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
 
Back
Top