View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Insert newline in cell through formula (excel 2003)

On the Format Cell's Alignment tab, select Wrap Text from the Text Control
section.

Rick


"Bart Wouters" <Bart wrote in message
...
Hi all,

I'm having troubles to simulate the alt+enter character into a formula of
excel 2003.

In previous versions, I could use something like

= "A" & char(10) & "B"

In this version, instead of displaying A and B in the same cell, on
another
line, I get A (a square symbol/character) B.

If I'm doing a copy/paste special (values), I have the same display. If I
enter the cell using F2 and simply pressing Enter, the square character is
replaced by the newline.

What am I doing wrong ? Have to immediatly have the newline !

Thanks in advance !
Bart