How to Split Names in Excel Into Two Columns | Scribe

    How to Split Names in Excel Into Two Columns

    • |
    • 0 step |
    • 30 seconds
      To begin, open your workbook in Excel.
      Click the Column Header that contains the names to be separated.
      Click "Data" from the top ribbon.
      Click "Text to Columns"
      Click "Delimited"\ Click "Next >"
      Click to check "Space." You can also indicate if your names are separated by something other than a space.\ Click "Next >"
      Click "Finish" to create first and last names in separate columns.
      Was this Scribe helpful?
      Save this document for future reference.
      click-target-circles-background
      This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe