To be more specific this is the first level of validation i will be performing in excel using the conditional formatting to highlight cells in a column range which have exceeded 1000 characters.

Quote Originally Posted by Pavan Renjal View Post
Hi Norie! If you copy from inside of the cell you can avoid quotes, and the count will be 1602. Notepad gives me the count i need, earlier i used to validate with Notepad ++ to get the character count to load the data into production(there is a restriction of 1000 characters). I wanted initial validation to happen in excel itself, but the len function is not giving me the count i need.