How to Separate Names in Excel Into Two Columns | Scribe

How to Separate Names in Excel Into Two Columns

    1
    To begin, open your workbook in Excel.
    2
    Click the Column Header that contains the names to be separated.
    3
    Click "Data" from the top ribbon.
    4
    Click "Text to Columns"
    5
    Click "Delimited"\ Click "Next >"
    Click "Delimited"\
Click "Next >"
    6
    Click to check "Space." You can also indicate if your names are separated by something other than a space.\ Click "Next >"
    Click to check "Space." You can also indicate if your names are separated by something other than a space.\
Click "Next >"
    7
    Click "Finish" to create first and last names in separate columns.
    Click "Finish" to create first and last names in separate columns.