text to column - Free Excel Tutorial

How to Split Comma separated Values into Columns or Rows in Excel

January 22, 2019

This post will guide you how to separate comma delimited cells to new rows or columns in Excel. How do I split comma separated values into rows with Text to Column Feature in Excel. How to convert comma separated text into rows or columns with VBA Macro in Excel. Split Comma Separated Values into Rows… read more »

How to Split Date into Day, Month and Year in Excel

January 2, 2019

This post will guide you how to split date into separate day, month and year in excel. How do I quickly split date as Day, Month and Year using Formulas or Text to Columns feature in Excel. Split Date into Day Month and Year with Formulas Split Date into Day Month and Year with Text… read more »

How to Split Multiple Lines in One Cell into Separate Rows or Columns in Excel

November 14, 2018

This post will guide you how to split multiple lines in a cell into a spate rows or columns in Excel. How do I split cell contents into multiple cells with Text to Columns feature in Excel. Split Multiple Lines in a Cell into Multiple Rows or Columns Video: Split Multiple Lines in a Cell… read more »