Excel - Separate the contents of one cell into separate columns

This articles is about separating the contents in one cell into separate columns in excel .

Suppose we are copying text from notepad as shown below :

Pasting the above copied text into excel , will be clubbed into single column as shown below :

To Separate the contents of one cell into separate columns  , follow steps as shown in below screenshots :

Reference :

• http://office.microsoft.com/en-in/excel-help/split-names-by-using-the-convert-text-to-columns-wizard-HA010102340.aspx
  

See Also :

• http://www.allaboutmssql.com/p/microsoft-excel-powerpoint-and-power-bi.html