concantenatring 2 cells with with a line break

D

dick

I have info in 2 cells. I want to add the info from one cell into the other
cell but have the info from each cell show up on different lines within the
cell
 
C

CLR

In a third cell, put

=A1&" "&A2 and format that cell as "Wrap text"

Vaya con Dios,
Chuck, CABGx3
 
R

RagDyer

What Chuck really meant to say was:

=A1&CHAR(10)&A2

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
C

CLR

Yeah, RD, I did prototype that one first, but the "space" worked just as
well on my XL2k so I decided to post it instead.

Vaya con Dios,
Chuck, CABGx3
 
R

RagDyer

I doesn't work on my XL97, and you just made me run all the way to the front
office to check it on my XL2K, where it *also* doesn't work?!?!

Are you SURE?
 
R

RagDyeR

Now I know what you did.

You had your column *just* wide enough, OR your data *just* long enough, so
that "line wrap" would kick in automatically, due to the natural break at
the space.

That's cheating, and shouldn't count.<bg>
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Yeah, RD, I did prototype that one first, but the "space" worked just as
well on my XL2k so I decided to post it instead.

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

"Stuff happens" <vbg>........anyway, I do acknowledge the =A1&CHAR(10)&A2
way as being the better but I'm not sure why. Previously I did not take
into account that one or the other of the cells to be concatenated might
already have spaces between values therein, especially multiple
words...........still both methods are dependent upon column width and the
CHAR method will still break on spaces as well, but the CHAR method actually
works better when the column is wider than the longest string, and actually
forces the line-break where the "space" method continues to work to each
space in the concatenated string..........I guess in the long run, if you
have a wide column and WANT two lines exactly, then the CHAR method is
better........but the OP said "different lines" not just two lines, and in
some cases I personally find the appearance using the "space" method nicer,
(the devil made me say that).........anyway, now my cat is on my keyboard,
and he's telling me that it's time for my medication.........

Vaya con Dios,
Chuck, CABGx3
 
L

Lanak Suri

=concatenate(text1,tex2,...) This formula joins several text strings to one
text string. Or simple try like =A1&" "&A2. And you can special past as value
only to any cell.
 
Top