Home |
Search |
Today's Posts |
#6
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
How do I align cells in Excel onto one line? | Excel Worksheet Functions |