First, Excel crosses the merge location
Versions 2007 and 2010 Excel across the merge feature, click Start-Alignment-the Drop-down press next to center after merging to find Excel spanning merge features, such as the screenshot below.
Version 2003 Excel spans the merge feature, click the Tools Customize command category to format command button to find the spanning merge button, you can drag it to the menu toolbar for use.
Excel Two column merging differs in the way the two columns are merged, depending on the specific data source.
Excel two column merge apply one: date merge
The date of the AB Two column is merged in column C, because the date is more special, the direct use of the join symbol merge will appear formatting problems, so C2 cell input formula: =text (A2, "yyyy-m-d") & "/" &text (B2, "yyyy-m-d"), To merge two columns.
Excel Two column merge apply two: text and percent semicolon merge
Column A is text, and B is a percentage. Merges two columns of content in column C and retains the percent symbol. If you use =A2&B2 directly, you will not get the desired effect. Formulas for D3, D4 cells can merge two columns correctly.
Excel two column merge application three: Urban merger
A is listed as a city, B is a district, column C is merged into two columns, and the "Sichuan Province" is added to the top three words. C1 Input Formula: = "Sichuan province" &a1&b1, Drop-down replication completes two columns of merge.
