The other day, I was working on a statistical report in Excel 2013 where I wanted to split a cell(a column) into two. I was looking for an option in Excel 2013 and Text to Column feature served my purpose. Here is what I did:
- Select/Highlight the cell(s) that you would like to split .
- Now under Data tab, click on Text to Columns, that opens a dialog box.
- In the dialog box, choose the best option to split your text. You have two options
- Delimited – Splits text with a specified delimiter like comma, space, tab etc.
- Fixed Width – Splits cells with a fixed value that is set.
- If you select Delimited, you need to specify the delimiter in the next page. With the latter, you can drag the pointer to a particular width underData Preview and click on Next.
Once you are done, click on OK and now you get the cells split as you specified.
Special Bonus: Download our free PDF Excel 2016 tips guide. Include 6 essential Excel 2016 how-tos to boost your productivity.
- You can specify the type/format of the new column under Column data format.
- Also, you can modify the destination of new column(which is the next cell by default) under Destination.