View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Totteridge Ram Totteridge Ram is offline
external usenet poster
 
Posts: 8
Default ALT-ENTER in a concatenate formula

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.