I am using a large spreadsheet and i need to flag the text cells that have
over 40 charactors in them can anyone please help.

use an adjacent column of cells:
=len(a1)

Then you can filter based on that column.

Or use format|conditional formatting
I selected my range (and had A1 the active cell).
format|conditional formatting
formula is: =LEN(A1)40
and gave it a nice pattern.

or you may want to use data|validation to try to stop it when they're entering
the data.



Lisa wrote:

I am using a large spreadsheet and i need to flag the text cells that have
over 40 charactors in them can anyone please help.

--

Dave Peterson

Many Thanks, was a great help.

Lisa

"Dave Peterson" wrote:

use an adjacent column of cells:
=len(a1)

Then you can filter based on that column.

Or use format|conditional formatting
I selected my range (and had A1 the active cell).
format|conditional formatting
formula is: =LEN(A1)40
and gave it a nice pattern.

or you may want to use data|validation to try to stop it when they're entering
the data.



Lisa wrote:

I am using a large spreadsheet and i need to flag the text cells that have
over 40 charactors in them can anyone please help.

--

Dave Peterson