Split names into several Excel cells

Name Splitter in detail

The Name Splitter add-in for Microsoft Excel can quickly and easily split names that are in one cell into individual names in individual cells. For example, if a cell contains the entry "John R. Smith" or "Smith, John R", the Name Splitter creates a new worksheet with "John", "R", and "Smith" in separate cells. The Name Splitter is totally menu drive and very fast.

Suppose you have a list like this:

Or like this

The Name Splitter for Excel will convert this to a table like the following:

The Name Splitter works by first asking for you to select the range of cells containing the names. It then displays the following dialog which asks you to identify the arrange of the input name list:

You are then asked to specify the output option on the middle names:

Lastly, you are given the option to the specify the courtesy titles that are recognized as titles or to use the default list. Once you complete this last dialog, the Name Splitter creates a new worksheet with the names split per your selections.

See also in "Excel - Data management - merge, convert, delete"

• Address Assistant - Split addresses from one cell into multiple cells.
• Consolidation Assistant - Consolidate data from Excel workbooks or worksheets.
• CSV File Creator - Create a CSV file from Excel workbooks / worksheets.
• Data Assistant for Excel - Make table form data applicable for Excel pivot tables.
• Data Cleaner for Excel - Remove spaces, Change text case, Replace / modify text, etc.
• Data Extraction Assistant for Excel - Extract data from one worksheet to many spreadsheets.
• Data Loader for Excel - Easy loading, processing, and transferring data .
• Filter Assistant - Filter multiple Excel spreadsheet columns at a time.
• Formula Manager - Manage all formulas in Excel worksheets easily.
• Formula Ref Changer and Sheet Index Creator - Change Excel formula reference types.
• List Assistant - Easy way to re-arrange rows in your Excel worksheet.
• Number Manager - Fill in the gaps in Excel workbooks.
• Report To Data Assistant - Convert text reports into Excel worksheet databases.
• Spreadsheet Assistant - Over 200 useful features for MS Excel.
• Text File Importer - Import text files with over a million lines into Excel.
• Text Manager - Change case in Excel, Join text to one cell, Remove spaces, etc..