• Home
• Products
  Complete Product List New Products Free Products Analysis Products Charting Products Data Products Macro Books Specialty Products Time Saving Products Workbooks/Templates Products by Others iPhone Applications
• Product Collections
  Productivity Suite Accounting Collection Business Analysis Collection Charting Collection Data Collection Macro Book Collection Risk Analysis Collection Time Saving Collection
• Save $'s
  Volume discounts Past customers discounts Buy a collection! Buy the Productivity Suite!
• Download
  Download Information Download Purchased Software Download Upgrades Download Trial Versions Download Free Products
• Support
  Support How to Contact Us Top Support Questions Money Back Guarantee Ordering FAQ's Product FAQ's How to Open and Use Our Products Excel Problems & Solutions Links to other Excel sites How to repair Microsoft Excel Need more help? Let us connect computers
• Company
  About Add-ins.com LLC How to Contact Us Customer Feedback Policies License Agreement

Name Splitter for Microsoft® Excel® 97, 2000, 2002, 2003, 2007, and 2010 Split names in one column into multiple columns Easily handle courtesy titles and suffixes Handles names in first-last or last-first order Handles multiple middle names Separates names from addresses Converts "last name, first name" to       "first name last name"

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.

Another feature of the Name Splitter will convert a list of names in "Last Name, First Name" order to "First Name Last Name".  If you have company names mixed in with your people names, the Name Splitter has several options to prevent them from being modified.

Suppose you have a list like this:

or like this

The Name Splitter 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 arrangement 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 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.

The Name Splitter has over 150 courtesy titles and suffixes (including military titles) that it looks for and removes.  And you can easily create and use your own custom list of titles and suffixes.

In addition to being able to split names, the Name Splitter can also separate names from addresses.  For example if you have in a cell "George Burdell 1 Techwood Drive" the Name Splitter can split this into "George Burdell" in one cell and "1 Techwood Drive" in another.

Order online from our secure service. Get delivery in minutes!

US $24.95

Customers who viewed the Name Splitter also viewed:

• Address Assistant - Easily split addresses in one cell into multiple cells. Fix zip codes needing leading zeros.
• CSV File Creator - Create CSV files the easy way, without Excel's warning messages.
• Data Cleaner - Eliminate tedious manual cleaning of data
• Duplicate Finder - Quickly find and remove duplicates in one list or between two lists.
• Multi-Column Sorter - Sort up to ten columns at once!
• Word Shifter - Shift words from one cell to the next with just the click of a button.

View Cart US $24.95 Quantity Discount 2 10% 3 20% 4 30% 5-9 40% 10 or more 50%

Order online from our
secure service
Get delivery in minutes!

Order Risk Free
Money back guarantee
if not satisfied

Buy individually or
save by buying the Productivity Suite