Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2006

Tip: Looking for answers? Try searching our database.

How to sort column...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mare - 25 May 2006 11:35 GMT
Hi all
how can I sort column based on number of caracters in the cell.
Column is formated as text, values in cells are just numbers and
numbers and letters respectfully, number of caracters varies from 6 to
10, some of the cells in column have leading zeroes. I need to separate
all the cells which have 6 caracters(including leading zeroes).
I hope that explanation of my problem is clear.

Thanks in advance

Signature

Mare

Ardus Petus - 25 May 2006 11:45 GMT
Use a helper column with following formula:
Assuming your data is in column A:
=LEN(A1)=6
then copy down
and sort on that new column.

HTH
--
AP

> Hi all
> how can I sort column based on number of caracters in the cell.
[quoted text clipped - 5 lines]
>
> Thanks in advance
Mare - 25 May 2006 13:56 GMT
Thank you, for the fast solution.
Your solution for my problem was embarrasingly simple, thanks for your
patience with "us". Hopefully one day........

Signature

Mare

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.