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 the Text to Column feature which served my purpose.

Here’s how to split cells in Excel (works well also on Excel 2016)

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