Main /
Merge
Merging Cells with no data
- Hightlight Cells
- Format Cells
- Alignment Tab - Choose Merge Cells
CONCATENATE
- Merging Content onto a new cell =CONCATENATE(A14,B14)
Another way to concatenate Use "&"
- A2: 3
- B2: ="00"&A2 gives us 003
- B3: ="sc \\"&C2&" query ""USB-Defender"""
- gives us this...
- sc \\003Info1 query "USB-Defender"
Split a Merged Cell
Split merged cells
- You can split only cells that were previously merged.
- Select the merged cell.
- When you select a merged cell, the Merge and Center button also appears selected (selected: A toolbar button always has a border around it when it's selected, even when the pointer is not resting on the button.) on the Formatting toolbar.
- To unmerge cells, click Merge and Center .
- Note When the merged cell is split, the contents of the merged cell will appear in the upper-left cell of the range of split cells.
http://office.microsoft.com/en-us/excel/HP052510211033.aspx#SplitMergedCells