How to split worksheet cells in Excel 2013?

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.

More tips:

  • 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.

Leave a Comment: