I think i figured it out. You were probably looking for this =COUNTIF(G3:G1598,10) instead of =COUNTIF(G3:G1598,CODE(10)).

Quote Originally Posted by TMShucks View Post
You're welcome. Thanks for the rep.


I don't use Notepad++ so I can't offer an opinion. Another thought is that you get quotes added at the beginning and end because there are commas in the text and Notepad++ is trying to maintain the integrity of the cell contents.

Interestingly, I only see 6 carriage returns (char(10)) in both Excel and Word yet when I did the COUNTIF in Excel it showed 9. Confusing.


Regards, TMS