You've probably received an email with a heart, star or arrow in the subject line. For my job, I have a data set of ~6-10k emails per month and I calculate various stats. One stat I use is the number of these characters are in subject lines. To get this, I have been using...
=LEN(SubjectLineA)-LEN(SUBSTITUTE(SubjectLineA,"Character1",""))+LEN(SubjectLineA)-LEN(SUBSTITUTE(SubjectLineA,"Character2",""))+...... (repeated for the 50+ characters)
Result: SubjectLineA had 4 special characters (of the 50+)
but I've reached some limit with this approach where Excel (2010 and 2013 w/12GB ram) locks up when I modify the formula or add additional characters. It's not a calculation issue.
I have been unable to find another way to tackle this. Any ideas?
-J
Bookmarks