The Split-Up Words is for splitting up words in a column of cells (, each of the cells may contain more than one word, ) into individual columns. For example:
A common application is the split up of first names, middle names and last names in a list of full names. (And in fact, this function was specially built for such tasks.) For example:
Split-Up Words has two modes: General Mode (for splitting up each word into individual cells) and Names Mode (designed to handle names). You can switch between the two modes with multipage tabs on the form. (See the figures below with the two modes displayed side-by-side.)
Unlike normal text data, names often have “First Name”, “Middle Name”, and “Last Name”. A “Middle Name” may sometimes contain more than one string (or word), or there could be no “Middle Name” at all in a name. Therefore, just extracting the first and/or last names from a large list of names could cause a headache. There could be a number of possibilities.
Excel Power Expander has very intelligent built-in logic which simplifies the tedious task for you.
Like other Text Manipulation functions, Split-Up Words Wizard was designed to process huge data files. It has been thoroughly tested for its practical usability on huge real-life data files.
When processing a huge lists of data, Excel Power Expander will inform you of the progress through the status bar at the bottom of the screen. Besides, the software will make sure that your computer is not “frozen” while processing and you can interrupt the operation at any time by pressing the Esc key on your keyboard. After the interruption, you’ll be asked whether you want to continue processing or to abort. Such nice, advanced, and stable facilities are definitely only available in Excel Power Expander!!
The Excel Power Expander software comes with an example file which contains 10,000 sample names for this demonstration. Follow the steps below, and you can see how the function process large amount of real-life data.
the file “Plenty of names.xls” in the “Example” folder.
2. Select the names in column A. (With A1 selected, press Ctrl+A.)
3. Run “Split-Up Words” from the “Expander” menu. Choose the “Names” tab, and choose “Family name at the end”. Choose the other options as shown in the figure below.
4. In Step 2, you choose where to put the output. In this example, we choose “Adjacent to the source range”. (See figure below.) Click “Finish” to start processing the data.
5. The finished result is as shown in the figure below. First names, Middle names and Last names are neatly placed on the right, adjacent to the original data (names). Now, the output can be useful for various purposes, such as mail merge.