Dave, thank you for the link
"Dave Peterson" wrote:
Chip Pearson has a very nice addin that will help determine what those
characters a
http://www.cpearson.com/excel/CellView.aspx
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.
--
Dave Peterson