Spreading data across Columns in Excel Without VBA Code

In my previous article as you learnt how to split data using VBA SPLIT() function. In this Article I am going to explain you how to separate the data across columns of a cell without excel VBA. Microsoft Excel has a built-in function called Text-to-Columns under Data ribbon (refer the Pic 1). Using this option user can split the data [...]

How to Import Delimited Text File in Excel

In this article, I am going to show, how can we export Delimited Text Files in Excel. For Example, you have a file which is Comma delimited Text file or Pipe Delimited Text File etc. This file you want to export in to Excel in such a way that Delimiter is treated as a Column. It mean wherever it finds [...]