DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Combine Columns (merge)

Select any columns within a table to merge into a new combined column. DigDB allows you to select the order of the columns and set any in-between filler texts.
  1. Select a single cell in your table, then invoke 'DigDB->Column->Combine...'

    Combine Columns (merge)
    Practice file - combine-columns-demo.xls (16k)

    The table will be automatically selected. You can now select the columns to combine, select the order, and set the in-between filler texts.

    Combine Columns (merge)

  2. Suppose we want to combine the two columns to create a new column 'Full Name', and we want the column to look like 'Ray, David' (Last Name + ', ' + First Name):
    1. Use the dropdown to select 'Last Name', click the upper 'Add >>' button to add the column to the combine pool
    2. Enter ', ' (with the space) into the text input box below the dropdown, click the lower 'Add >>' button to add. This is the filler text inserted in-between the two columns.
    3. Use the dropdown to select 'First Name', click the upper 'Add >>' button to add

    Combine Columns (merge)

  3. Click 'OK' to combine. Result - a new column will be appended to the end of the table, with the combined value you just entered.

    Combine Columns (merge)

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.