Spread the loveMicrosoft Excel is one of the most widely used tools when it comes to managing and organizing data. One of the frequent tasks is separating the first and last names in Excel. This task ...

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

In specific instances in your Excel worksheet; where you have full names combined in a column, you would want to separate the first and last name, but you don’t know how. This tutorial seeks to solve ...

How to merge names split between two columns in... Over the past few years I have created a database of around 23,000 records in an Excel spreadsheet. For reasons which are now no longer applicable, ...