How to Split Names in Excel Into Two Columns | Scribe

    How to Split Names in Excel Into Two Columns

    • |
    • 7 steps |
    • 30 seconds
      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.