TEXT CELLS OVER 40 CHARACTERS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Many Thanks, was a great help.

Lisa

Dave Peterson said:
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.
Click to expand...
 

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

Newbee 12
cell only accept dates 2
How do you limit the number of charactors in a cell? 2
Excel Assistance with Fomula 0
Removing Spaces 16
Payroll Calculation - Help Needed 3
IF formula 3
How to Find Specific Text in a Text String 2

Back
Top