Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to merge 2 cells and have them on 2 separate lines in a cell
how to merge 2 cells and have them on 2 separate lines in that cell, one
above the other. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to merge 2 cells and have them on 2 separate lines in a cell
Try this:
=A1 & CHAR(10) & B1 Then set the cell to wrap text. CHAR(10) is equivalent to Alt-Enter if you typed it yourself. Hope this helps. Pete On Aug 13, 4:33*pm, Kerry wrote: how to merge 2 cells and have them on 2 separate lines in that cell, one above the other. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to merge 2 cells and have them on 2 separate lines in a cell
I don't understand what you're trying to do. Merging (shudder) is usually
done to give the appearance of one cell. However, you state that you want the 2 cells to appear as seperate lines. If you want them to appear seperate, why nto leave them seperate? Merging tends to cause so many more problems, as it interferes with copy, paste, sort, VB, formula extrapolation, etc. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Kerry" wrote: how to merge 2 cells and have them on 2 separate lines in that cell, one above the other. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to merge 2 cells and have them on 2 separate lines in a cell
Try :
=A2&char(10)&B2 Make sure your formula cell is set to Wrap Text (Format/Cells/Alignment) "Kerry" wrote: how to merge 2 cells and have them on 2 separate lines in that cell, one above the other. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to merge 2 cells and have them on 2 separate lines in a ce
That is just what I needed, worked perfect.
Thanks "Pete_UK" wrote: Try this: =A1 & CHAR(10) & B1 Then set the cell to wrap text. CHAR(10) is equivalent to Alt-Enter if you typed it yourself. Hope this helps. Pete On Aug 13, 4:33 pm, Kerry wrote: how to merge 2 cells and have them on 2 separate lines in that cell, one above the other. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to merge 2 cells and have them on 2 separate lines in a ce
That is just what I needed, works perfect.
Thanks "Sean Timmons" wrote: Try : =A2&char(10)&B2 Make sure your formula cell is set to Wrap Text (Format/Cells/Alignment) "Kerry" wrote: how to merge 2 cells and have them on 2 separate lines in that cell, one above the other. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to merge 2 cells and have them on 2 separate lines in a ce
You're welcome, Kerry - thanks for feeding back.
Pete On Aug 13, 5:07*pm, Kerry wrote: That is just what I needed, worked perfect. Thanks "Pete_UK" wrote: Try this: =A1 & CHAR(10) & B1 Then set the cell to wrap text. CHAR(10) is equivalent to Alt-Enter if you typed it yourself. Hope this helps. Pete On Aug 13, 4:33 pm, Kerry wrote: how to merge 2 cells and have them on 2 separate lines in that cell, one above the other.- Hide quoted text - - Show quoted text - |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to merge 2 cells and have them on 2 separate lines in a ce
Thank you for the reply!
"Kerry" wrote: That is just what I needed, works perfect. Thanks "Sean Timmons" wrote: Try : =A2&char(10)&B2 Make sure your formula cell is set to Wrap Text (Format/Cells/Alignment) "Kerry" wrote: how to merge 2 cells and have them on 2 separate lines in that cell, one above the other. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
separate one cell into several cells | Excel Discussion (Misc queries) | |||
Separate lines in Excel cell | Excel Worksheet Functions | |||
merge a wordfile of names & addresses to an excel separate cells | Excel Worksheet Functions | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) |