Separate First, Middle and Last Names in Excel
On the next screen, select Space and Other fields > type “ ,” (Comma) in the little box next to “Other” and click on the Next button.ģ. Select the entire Column containing combined Names > select the Data tab in the top menu bar and click on Text to Columns option in “Data Tools” section.Ĥ. If the names are written in format LastName, FirstName, you can Follow the steps below to remove Comma and separate First, Last Names.Ģ. Remove Comma, Separate First and Last Names In Excel Once you click on the Finish button, you will immediately see the Names separated into First and Last Names.Īs you can see in above image, the Names have been separated into two different columns. On the next screen, you can choose the destination for First and Last Names or go with the existing selection and click on the Finish button.Ħ. On the next screen, select the Space field and click on Next.ĥ. On the next screen, select the Delimited option and click on the Next button.Ĥ. Select the entire Column containing Names > click on the Data tab in the top menu bar and click on Text to Columns option in “Data Tools” section.ģ. Open the Excel File containing Names that you want to separate.Ģ.
Separate First and Last Names Using Text to Column Wizardįollow the steps below to separate Fist and Last Names using Text to Columns wizard as available in Microsoft Excel.ġ. While it is possible to Separate First and Last Names using Excel formulas, the easiest way to separate First and Last Names in Excel is to use ‘Text to Column Wizard’ as available in Microsoft Excel. When the Names are stored in a single Excel column, they are usually stored as FirstName LastName, LastName, FirstName (comma separating the two) and also as FirstName Midinitial LastName.
0 kommentar(er)
