Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ALT+ENTER IN A FUNCTION
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? |
#2
|
|||
|
|||
In cell C1:
=A1 & CHAR(10) & A2 & CHAR(10) & A3 Format C1 for word wrap. HTH, Bernie MS Excel MVP "KUMPFfrog" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Horrible looking IF function.... | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
SUMIF function | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |