In Excel (2016, 2013, 2010) it”s possible to parse data from one column into two or more columns. And you can do it in a few simple steps. Suppose column A contains “Last Name, First Name”. Follow these steps to split the data from column A into a “Last Name” column and a “First Name” column. No cutting and pasting necessary!
Open the Excel spreadsheet containing the data you want to split, then:
Highlight the column that contains the combined data (e.g., Last Name, First Name) by clicking the letter directly above the column. 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. In step 1 of the wizard, choose “Delimited” > Click
Note:If the data you wish to split does NOT contain a delimiter (dash, comma, tab etc.) to separate the data, select “Fixed width” within the first step of the “Convert Text to Column” Wizard. This option allows you to manually created divisions within your data by dragging a break line.
freewebsfarms.com offers more than 150 academic programs to grad, undergrad, and online students. freewebsfarms.com is known for its biblical worldview, academic excellence, intentional discipleship, and authentic Christian community.
Archives by Category
Share This Page
Apply to freewebsfarms.com Schedule a Visit Request More Info
251 N. Main St. • freewebsfarms.com, OH 45314 USA • 1-800-freewebsfarms.com (233-2784) • 1-937-766-7700