| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does Alt-Enter insert a non-printing character in a cell string?
You can force a carriage return linfeed into an Excel cell to cause the
visible text to wrap by using the key combination Alt-Enter. But does doing that actually insert something into the text string of that cell? Would there be an invisible chr(010) + chr(013) in the text string? -- Henry Stock, Network Administrator onProject.com 3 Wing Drive Cedar Knolls, NJ 07927-1006 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Does Alt-Enter insert a non-printing character in a cell string?
an invisible char(10).
You can check it out be using the LEN function. -- Regards, Tom Ogilvy "Henry Stock" wrote in message ... You can force a carriage return linfeed into an Excel cell to cause the visible text to wrap by using the key combination Alt-Enter. But does doing that actually insert something into the text string of that cell? Would there be an invisible chr(010) + chr(013) in the text string? -- Henry Stock, Network Administrator onProject.com 3 Wing Drive Cedar Knolls, NJ 07927-1006 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Does Alt-Enter insert a non-printing character in a cell string?
Thanks Tom. I appreciate the help.
"Tom Ogilvy" wrote in message ... an invisible char(10). You can check it out be using the LEN function. -- Regards, Tom Ogilvy "Henry Stock" wrote in message ... You can force a carriage return linfeed into an Excel cell to cause the visible text to wrap by using the key combination Alt-Enter. But does doing that actually insert something into the text string of that cell? Would there be an invisible chr(010) + chr(013) in the text string? -- Henry Stock, Network Administrator onProject.com 3 Wing Drive Cedar Knolls, NJ 07927-1006 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Does Alt-Enter insert a non-printing character in a cell string?
Check further with some VBA:
Sub checkASC() Dim i For i = 1 To Len(Selection) MsgBox Mid(Selection, i, 1) & " is ASC code " & Asc(Mid(Selection, i, 1)) Next i End Sub "Tom Ogilvy" wrote in message ... an invisible char(10). You can check it out be using the LEN function. -- Regards, Tom Ogilvy "Henry Stock" wrote in message ... You can force a carriage return linfeed into an Excel cell to cause the visible text to wrap by using the key combination Alt-Enter. But does doing that actually insert something into the text string of that cell? Would there be an invisible chr(010) + chr(013) in the text string? -- Henry Stock, Network Administrator onProject.com 3 Wing Drive Cedar Knolls, NJ 07927-1006 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a hard break (alt enter) in a concatenated string | Excel Discussion (Misc queries) | |||
| insert "-" as fourth character in number string | Excel Discussion (Misc queries) | |||
| How to put line feed in a cell using a character not Alt/Enter | Excel Discussion (Misc queries) | |||
| Help Me!!. can not set the string with len more than 255 character to the value cell | Excel Programming | |||
| Macro to insert "0" in front of 4 character string | Excel Programming | |||
Linear Mode
