Does Alt-Enter insert a non-printing character in a cell string?

[Henry Stock]

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?

 

[Tom Ogilvy]

an invisible char(10).

You can check it out be using the LEN function.

 

[Henry Stock]

Thanks Tom. I appreciate the help.

an invisible char(10).

You can check it out be using the LEN function.

 

[Steve]

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