DigDB           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

Split Column

1. Split by Delimiter - Choose any delimitor, choose to split by the first or last appearance of the delimiter. The text is split into 2 parts: (1) the 'before'-delimitor part, (2) the 'remainder' part. For example:
   '1234H56 H09' split by LAST delimitor 'H' = '1234H56 ' + 'H09'
   '1234H56 H09' split by FIRST delimitor 'H' = '1234' + 'H56 H09'

2. Split by Length - Choose the number of characters, choose to split by the first or last number of characters. The text is split into 2 parts: (1) the first or last x number of characters you want, (2) the remainder. For example:
   '1234H56 H09' split by LAST 3 characters = '1234H56 ' + 'H09'
   '1234H56 H09' split by FIRST 4 characters = '1234' + 'H56 H09'

Split Column by Delimiter

1. Select a single cell in the column you want to split, then invoke 'DigDB->Column->Split->by Delimiter...'

   
   Practice file - split-column-demo.xls (16k)

   The column will be automatically selected. You can now select how to split.

   

2. Suppose we want to separate out the 'Last Name' part, that is to set split by the Last Space. Note we can split by any text by typing the text into the input box.

   

3. Click 'OK' to split. In result, the original column is unchanged; two new columns will be added: the first part consists the text before the delimitor (excluding the delimitor), the second part is simply the remainder (including the delimitor).

   

   In our case, the remainder have a preceding space in it. To get rid of the space, you can either use DigDB->Column->Trim to trim it. Our you can further split it by length, i.e., split the remainder column by first 1 character.

Split Column by Length

1. Following the above example, after the split by delimitor, we have a 'Remainder' column with a preceding space in it. To get rid of the preceding space means to split the column by the first 1 character. Therefore, click a single cell in the column, invoke 'DigDB->Column->Split->by Length...'

   

2. Set how to split:

   

3. Split result. Each cell is broken into two parts - (1) the first or last x number of characters you want, (2) the remainder

   

Need more?

• Browse the complete list of DigDB's powerful features listed on the front page.
• If you see errors or things not working, check out our error reference page.

---

Features | Testimonial | Download | Purchase | FAQ | Contact

Copyright © 1999-2007 All rights reserved

DigDB           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 and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.