ExcelBanter - TEXT CELLS OVER 40 CHARACTERS

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - TEXT CELLS OVER 40 CHARACTERS (https://www.excelbanter.com/excel-discussion-misc-queries/48673-text-cells-over-40-characters.html)

Lisa

TEXT CELLS OVER 40 CHARACTERS

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.

All times are GMT +1. The time now is 10:42 PM.