When you click on the Merge Assistant for Microsoft Excel a dialog appears that asks for a range of cells one column wide or one row wide. This identifies both the first cell in each row (or column) to be merged and the rows (columns) to be merged. The next dialog asks for the additional columns (or rows) to be included. You can select multiple columns (or rows) at one time and click on the Add button. The third dialog that appears asks for merge options. You can merge based on cell appearance or cell value. Merging on cell appearance allows one to merge cells that have been formatted with leading zeros and to retain the leading zeros. The last dialog gives you the concatenation options.
Requirements:
Microsoft Excel 97, 2000, 2002, XP, 2003, 2007, or 2010
Comments not found