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.

Quote Originally Posted by Norie View Post
When I copy the text from A2 into Notepad++ quotes are added at the beginning and end.

Why do you need a specific count of 1602?