Alt Enter in a cell

J

JJ

Is there a way to account for a line space (alt enter) in an excel formula?
For instance if there are three cells (ie...address, city, and state), is it
possible to concatenate them, but after the address the function inserts an
alt enter so it moves down a line space and then have the city and state
under the address all in one cell? So basically is there a way to tell a
formula that it needs to alt enter without having to do it manually?
 
B

Bob Phillips

=A1&CHAR(10)&B1&CHAR(10)&C1

and make sure wrap text is set

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
M

Max

Assuming cols A to C contain the text to be concat,
from row1 down

With col D formatted to wrap text (this is required):
Put in D1: =A1&CHAR(10)&B1&CHAR(10)&C1
Copy D1 down
 
Top