Sorting by Number of Characters

  • Thread starter Thread starter cny2
  • Start date Start date
C

cny2

Has anyone ever tried to sort records by number of characters? I need
to go through a very large medication document and need to sort out the
meds that are 30 characters or less. Anyone have any ideas on how to do
this?
Thanks!
 
Use a helper column.

If the meds are in column A, in column B (or the next blank column) enter

B1: =LEN(A1)

and copy down.

Sort both A and B on column B (or use Autofilter to display only those
cells in column B with a value of <=30.
 
One way
In a helper column =len(a1)
Copy formula down and sort.
Alteranative to sorting is auto filter.
HTH
 
One way is to add a "helper" column.

Enter this formula in the column:

=IF(LEN(A1)>=30,"A","B")

Now, select both columns, and sort on the "helper".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Has anyone ever tried to sort records by number of characters? I need
to go through a very large medication document and need to sort out the
meds that are 30 characters or less. Anyone have any ideas on how to do
this?
Thanks!
 
Back
Top