Thread
:
Insert newline in cell through formula (excel 2003)
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)
external usenet poster
Posts: 2,202
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
Reply With Quote
Rick Rothstein \(MVP - VB\)
View Public Profile
Find all posts by Rick Rothstein \(MVP - VB\)