Add-ins.com home page
Microsoft Office Marketplace logo
Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week
 

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!

Add to shopping cart

  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

Add to shopping cart

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

  CSV File Creator
  Colored Cells
      Assistant
  Data Loader
  Duplicate Finder

  Lookup Assistant
  Macros Made Easy
  Macro Examples
  Password Assistant
  Spreadsheet
      Assistant
  Waterfall Chart
      Creator

Recently Viewed


Home * About * Contact * Feedback * Upgrades * Money Back Guarantee * FAQ's
Download Information * Ordering Questions * Support
Product List * New Products * Free Products * Trial Versions * Products by Others

Copyright 2011 Add-ins.com LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of Add-ins.com LLC.
Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.