![]() Under "Column data format," choose "General.".Check the box next to "Treat consecutive delimiters as one.".For example, if your column reads “Smith, John” you would select “Comma” as your delimiter. A delimiter is the symbol or space which separates the data you wish to split.In step 1 of the wizard, choose “Delimited” > Click.Click the “Data” tab in the ribbon, then look in the "Data Tools" group and click "Text to Columns." The "Convert Text to Columns Wizard" will appear.Highlight the column that contains the combined data (e.g., Last Name, First Name) by clicking the letter directly above the column. ![]() Open the Excel spreadsheet containing the data you want to split, then: ![]() Follow these steps to split the data from column A into a "Last Name" column and a "First Name" column. Suppose column A contains "Last Name, First Name". In Excel (2016, 2013, 2010) it's possible to parse data from one column into two or more columns.
0 Comments
Leave a Reply. |