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 !
--------------------------------------------------------------------
"CLR" wrote in message
...
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
"RagDyer" wrote in message
...
What Chuck really meant to say was:
=A1&CHAR(10)&A2
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"CLR" wrote in message
...
In a third cell, put
=A1&" "&A2 and format that cell as "Wrap text"
Vaya con Dios,
Chuck, CABGx3
"dick" wrote in message
...
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
|