Finding Character number for ALT-Enter
Alt-Enter is Char(10)
"Bob Ptacek" wrote:
I need to count the number of special characters in a cell (ALT-Enter). Based
on a similar questions for Tab, the solution for tabs in A9 was
=LEN(A9)-LEN(SUBSTITUTE(A9,CHAR(9),""))
I am assuming this would work for me but I can't find how to look up what
the values for the 255 character so I can search for the Alt-Enter value.
I'm running Office 2003 and would be grateful for any guidance.
|