| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change the color of the cell when someone enter any number or character? | New Users to Excel | |||
| How can I change the color of the cell when someone enter any number or character? | Charts and Charting in Excel | |||
| Finding/counting a given character within a cell | Excel Worksheet Functions | |||
| finding rightmost location of a character | Excel Worksheet Functions | |||
| Finding a character type within a cell | Excel Worksheet Functions | |||
Threaded Mode
