ALT+ENTER IN A FUNCTION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I try to use ALT+ENTER in a function, but the result is a continous line.
ex.
C1=A1
&A2
&A3

Is there any way to produce a result in C1 with hard breaks?
 
In cell C1:

=A1 & CHAR(10) & A2 & CHAR(10) & A3

Format C1 for word wrap.

HTH,
Bernie
MS Excel MVP
 

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

CHAR(10) = ALT+ENTER?? 13
Copy Excel functions formula and auto refresh refresh 3
Cell Range Split into Multiple Cells 3
Automatically Entering Values 3
SUMIF "value if false" not working 2
How to check whither a text is existed 3
how to use if formula in list (data validation list) 1
multiplication of two array in a particular way 2

Back
Top