How to Separate Names in Excel Into Two Columns | Scribe
    logged out logo

    How to Separate Names in Excel Into Two Columns

      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
      0 Selected
      This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe