Excel Sorting

  • Thread starter Thread starter Paul Miller
  • Start date Start date
P

Paul Miller

i would like to get excel to sort
========================================
Go dear.
Go now and getsome sleep.
Go to bednow.
Good evening Ratcliffe.
=========================================
from lest to most letters including punctuation. to look
like this
=========================================
Go dear.
Go to bednow.
Good evening Ratcliffe.
Go now and getsome sleep.
=========================================
I would appresate any help you can give.

thanx,
paul
 
Hi Paul
use a helper column. If these values are in column A enter the
following in B1
=LEN(A1)
copy down and use column B for sorting
 
Thanx so much frank
-----Original Message-----
Hi Paul
use a helper column. If these values are in column A enter the
following in B1
=LEN(A1)
copy down and use column B for sorting

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Back
Top