ALT-ENTER in a concatenate formula

T

Totteridge Ram

Hi all

I have the formuale =concatenate(A1,CHAR(10),A2), expecting A1 and A2 to be
on different lines. But all I get is this the two figures on the same line
with a funny symbol in between (it looks like a square with a bold line on
top and bottom).

I've also tried CHAR(13) but no luck.

Can you help? Thanks.
 
N

NBVC

Totteridge said:
Hi all

I have the formuale =concatenate(A1,CHAR(10),A2), expecting A1 and A
to be
on different lines. But all I get is this the two figures on the sam
line
with a funny symbol in between (it looks like a square with a bold lin
on
top and bottom).

I've also tried CHAR(13) but no luck.

Can you help? Thanks.
Click to expand...

You have to change the cell format to Wrap Text Alignment

Go to Format|Cells and in the Alignment tab, pick Wrap Tex

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com
 
J

Jacob Skaria

Alt+Enter will work for cells without formulas...Here you need to set
'WrapText' from Format>Cells>Alignment

'Alternate
=A1 & CHAR(10) & A2

If this post helps click Yes
 
S

Stefi

You have also format cell>Adjust tab>Wrap
Regards,
Stefi

„Totteridge Ram†ezt írta:
 
Top