Hi shg, thanks for the response! Now how can i include all these carriage return, trailing line feed in my LEN function? Is there away to achieve this in a formula?

Quote Originally Posted by shg View Post
Notepad++ counts the carriage returns, the quotes, and the trailing line feed. That's the 10-character difference.