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
|