LEN formula excludes line feed?

Thats because i am using this as a sort of validation in excel sheet, and use this formula in conditional formatting to highlight the cells crossing a character count limit There is a character length restriction in the production environment where i will be loading this data.

Originally Posted by shg

No way I know of, sorry, but why is it important?