Filter on number of characters on a cell
 

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

Filter on number of characters on a cell
 

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 Hafer - TFE" wrote:
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

Filter on number of characters on a cell
 

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

"Max" wrote:

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 Hafer - TFE" wrote:
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

Filter on number of characters on a cell
 

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"D Hafer - TFE" wrote in message
...
Thanks! Much Appreciated....I have so many manipulations to make that I'm
forgetting some of these tricks.