View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Henry Stock Henry Stock is offline
external usenet poster
 
Posts: 13
Default 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