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.
 
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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

concatenate, char(10), and double quotes 3
Concatenate with gap suppression! 4
Concatenate problem 7
Concatenate with Line Feed not working 3
Concatenate with no duplicates 10
Sorting with alt-enter in the cells 2
BOLD WORDS IN CONCATENATE FORMULA 1
Display only unique values in CONCATENATE formula 4

Top