How to split worksheet cells in Excel 2013?

The other day, I was working on a statistical report in Microsoft Excel 2013 in which i had to split a cell(a column) into two. I was looking for a solution in Excel 2013 and found that the Text to Column feature serves my purpose pretty well.

Here’s how to split cells in Excel (we have also a post covering dividing text into columns on Excel 2016 and 2019):

  • Open Excel and navigate to your worksheet
  • 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
Special Bonus: Download our free PDF  Excel 2016 tips guide. Include 6 essential Excel 2016 how-tos to boost your productivity.
  • 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.

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.

Suggested next steps


Leave a Comment: