|
|||||||
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. It is compatible with Microsoft Excel 2010-2021 and Office 365. Suppose you have a list like this:
The Name Splitter will convert this to a table like the following:
The Name Splitter has over 150 courtesy titles and suffixes (including military titles) that it looks for and puts in the courtesy titles and suffixes columns. And you can easily create and use your own custom list of titles and suffixes. 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. 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. Lastly, if you need to combine the split names back together, there is a feature in the Name Splitter that does that! This allows you to put the name in the order you want, and use the parts you want, for example, going to first name last name only.
Customers who viewed the Name Splitter also viewed:
|
|||||||
|