Posts Tagged ‘separating names’

There may be times when you find yourself needing to separate a first and last name that are together into two separate columns.  Here is a quick and easy way to do this:

Note: Only do this if there is only a first and last name no middle initial, prefix, or Jr. Sr in the cells

Make sure there is a blank column beside the name

Highlight the cell or cells that you want to separate

Go to data on the toolbar>select text to columns

A box appears

Select fixed width>next

Click next on the next window

At the next window select finish

There you have it, instead of first and last name in one cell, they are now in two different cells.

Next week we will discuss separating names that have middle initials or middle names

Bookmarks

Tweet This Post