ALT-ENTER in a concatenate formula

  • Thread starter Thread starter Totteridge Ram
  • Start date Start date
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.
 
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
 
You have also format cell>Adjust tab>Wrap
Regards,
Stefi

„Totteridge Ram†ezt írta:
 
Back
Top