Excel is the most widely used form of spreadsheet, and this functionality differs from other Microsoft Office tools. Any numeric data can be easily entered, calculated, analyzed, stored and recalled in this program. Although all data is stored in a grid format of rows and columns, a number of operations are possible on them. One such feature is name parsing in Excel. Wondering what it means? Let me tell you. Suppose the structure of a name is composed of first name, middle name and last name. Normally, we will store the full name in a single column for identification purposes. But then you will want the full name separated into three parts and entered into three. different columns in the Excel sheet. This is known as parsing a single field across multiple fields in Excel.
You would need this name analysis whenever you need to email people with similar middle or last names. This article will walk you through the steps required to provide such a division of the name.
STEPS TO STOP NAMES IN MICROSOFT EXCEL
Suppose we have two columns, Column A and Column B. Initially we have the names that have the format, the first name followed by the last name in column A. Here, we will analyze them so that the first name appears in column A and the Last name appears in the column B.
Read also: How to display the number as a currency in Microsoft Excel
Open the Excel sheet with the full names stored in column A. Now, do a the right mouse button in the header of the column next to it. In my case, it's column B. Now select the option To insert. This column will be empty where we will store the surnames.
After completing the above step, choose the column header of A as shown in the screenshot below. It has names that require analysis. This is where we will apply the operations.
From the top menu where several tabs appear, choose the option Data. You will find an option below Text and columns. Click on it.
You will find a file Convert text to columns Wizard that appears on the screen. Under the header Original data type, choose the radio button first Delimited. Click on The next button below the wizard.
Here you will need to select the element that separates the text. In our case, the first and last names are separated by spaces. Check the box first Space. Right below, you can have a preview of the sheet that appears after applying the option. Once you are convinced, choose the file The next button.
In the next window, keep the default options as such and choose To finish.
In the spreadsheet you will now find the names divided into two columns. The first name appears in column A and the last name appears in column B.
Label the second column as Last for easy identification.
That is. You have now analyzed your names. Hope you found this article helpful.