Text to Columns

Text to Columns

As a new administrator I feel like I am getting a crash course in Google Sheets and Excel. In a previous post I covered how to combine the data from two columns into one by using the =concatenate function. Today I wanted to share how you can take the data from one column and separate it into two columns in Microsoft Excel.

1. Highlight the column that contains your data. To quickly do this click on the letter at the top of the column.

Screen Shot 2014-07-17 at 1.41.12 PM

2. Click on data on the top menu bar and then choose text to columns.texttoc

3. Make sure that you choose the delimited and click next.

Screen Shot 2014-07-17 at 1.23.44 PM

4. Choose where you want to split up your data and then click finish.

Screen Shot 2014-07-17 at 1.23.55 PM

5. If you get this prompt click ok .

Screen Shot 2014-07-17 at 1.24.08 PM

Like magic your data will now be separated into two columns!

 

Leave a Reply

Your email address will not be published. Required fields are marked *