Filter on number of characters on a cell

D

D Hafer - TFE

I'm working on a requirements spreadsheet in excel which is being turned into
a load file to go into a database. I have some text fields which have very
long character lengths.

Is there a way to auto filter on character lengths greater than a lenght of
255 characters?

Thanks in advance.

-Dave
 
M

Max

Use a helper col, eg
In C2, copied down: =LEN(B2)>255
where col B contains the text fields
Then autofilter on col C for TRUE
Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
D

D Hafer - TFE

Thanks! Much Appreciated....I have so many manipulations to make that I'm
forgetting some of these tricks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limiting the number of characters in a cell 5
How to remove a combination of letters and special characters 2
How to lookup based in the first 3 characters of a cell 2
Formula to validate characters within a string of data in aparticular cell 1
How do I get more than 255 characters into a cell? 3
number of characters in each cell 5
limit number of characters in cell 4
Defined number of characters 3

Top