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

Append value(s) to a column (before or after)

Append values to the cells in a table column. The value(s) can be placed before or after a cell's original text. Excel allows you to do this through a concatenate formula. The formula can get tricky when you want to concatenate special characters like quotation marks ("). Plus, it gets tedious when you are appending several values each of which requires copy and pasting. DigDB is just faster and easier.

    Append value(s) to a column (before or after)
    Practice file - append-column-demo.xls (16k)

  1. Select a single cell in table column you want, then invoke 'DigDB->Column->Append...'

    Append value(s) to a column (before or after)

    The column to append will be automatically selected.

    Append value(s) to a column (before or after)

  2. Enter the values you want to append. Suppose we want to create 2 new columns with words like 'Houston Restaurants', and 'Houston Taxi', simply enter the word ' Restaurants' (leave a preceding space) into the textbox, then click 'Add More...' button, enter ' Taxi' into the new textbox.

    Append value(s) to a column (before or after)

    Append value(s) to a column (before or after)

  3. Click 'OK' to append. Result - two new columns will be inserted into the table, each with the append values you entered.

    Append value(s) to a column (before or after)

If you have many values like 'Restaurants', 'Taxi' to append, you can type them into a range first, then invoke the append function. Choose the radio button 'Enter Values by Range', enter the range selector, then go to your append list and select. It's equivalent of entering them one by one in the append window.
    Append value(s) to a column (before or after)

    Append value(s) to a column (before or after)

    New appended columns will be inserted into the table:

    Append value(s) to a column (before or after)

DigDB's Column Append functions is designed to quickly manipulate table columns. There is another function Mix & Match Sets, which allows a user to mix any sets of cells to produce a list of all possible combinations. Mix-match-sets is especially useful for search engine marketing people to produce different permutations of keywords.

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact (resume builder | wehtwrjw )

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.