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.

Alt+Enter will work for cells without formulas...Here you need to set
'WrapText' from FormatCellsAlignment

'Alternate
=A1 & CHAR(10) & A2

If this post helps click Yes
---------------
Jacob Skaria


"Totteridge Ram" wrote:

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.

You have also format cellAdjust tabWrap
Regards,
Stefi

€žTotteridge Ram€� ezt Ã*rta:

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.