PC Review


Reply
Thread Tools Rate Thread

Can I filter for "number of characters in a cell"?

 
 
suestew
Guest
Posts: n/a
 
      15th Dec 2008
I want to filter all the cells that have more than 1000 characters.
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      15th Dec 2008
Use another column with formulas like:
=len(a2)
and drag down

Then you can include this column in your autofilter range.

suestew wrote:
>
> I want to filter all the cells that have more than 1000 characters.


--

Dave Peterson
 
Reply With Quote
 
suestew
Guest
Posts: n/a
 
      15th Dec 2008
Yeah - thank you.

So if I want the length to be 1000 or more, what would that look like?

=len(1000) or just pick a cell that has more than 1000 and go off that one?

I'm assuming your a2 below refers to a cell with the length of characters I
am trying to filter.


"Dave Peterson" wrote:

> Use another column with formulas like:
> =len(a2)
> and drag down
>
> Then you can include this column in your autofilter range.
>
> suestew wrote:
> >
> > I want to filter all the cells that have more than 1000 characters.

>
> --
>
> Dave Peterson
>

 
Reply With Quote
 
suestew
Guest
Posts: n/a
 
      15th Dec 2008
Never mind, I figured it out!!! You're a genius!

"Dave Peterson" wrote:

> Use another column with formulas like:
> =len(a2)
> and drag down
>
> Then you can include this column in your autofilter range.
>
> suestew wrote:
> >
> > I want to filter all the cells that have more than 1000 characters.

>
> --
>
> Dave Peterson
>

 
Reply With Quote
 
Chip Pearson
Guest
Posts: n/a
 
      15th Dec 2008
The easiest way to do this is to insert a column next to the test data
and use the formula =LEN(A1)>1000 . This will return TRUE or FALSE for
each cell. Filter on the TRUE values of this column.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Mon, 15 Dec 2008 11:39:05 -0800, suestew
<(E-Mail Removed)> wrote:

>I want to filter all the cells that have more than 1000 characters.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter on number of characters on a cell D Hafer - TFE Microsoft Excel Misc 3 3rd Sep 2009 01:50 PM
strip characters from a "number" like string skiing Microsoft Excel Discussion 27 11th Jul 2008 10:22 PM
Limiting a Column to "X" Number of Characters Wayne Microsoft Excel Misc 1 25th Jun 2008 07:21 PM
Number of characters in "SELECT * from ExcelSheetName" =?Utf-8?B?R2FyeQ==?= Microsoft ADO .NET 3 5th Jul 2006 05:38 PM
Limit the number of characters given a "Box" size Mark Microsoft ASP .NET 2 31st Jan 2006 06:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:16 PM.