Practice file - split-column-demo.xls (16k)
The column will be automatically selected. You can now select how to split.
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.
Copyright © 1999-2007 All rights reserved
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