View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Ptacek Bob Ptacek is offline
external usenet poster
 
Posts: 6
Default Finding Character number for ALT-Enter

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.