How to convert txt to Excel Columns?

         Select the cells that contain the text you want to split.

           How to convert txt to Excel Columns?

  • Go to the Data tab on the Excel ribbon.How to convert txt to Excel Columns? 

  • Click on Text to Columns Option.How to convert txt to Excel Columns?


  • Choose Delimited or Fixed width, then click Next: 

           

  •     Delimited: Use this if the text is separated by commas, tabs, spaces, or other characters.How to convert txt to Excel Columns? 


  •     Fixed width: Use this if the text is aligned in columns with spaces.How to convert txt to Excel Columns? 


  • Choose your delimiter (e.g., Comma, Tab, Space, Other).


  • Click Finis                How to convert txt to Excel Columns?