Convert Text from .txt to columns in excel

Hi All,

Looking for a macro to Open the text file from a path and convert it to text to Column in excel.
Basically every time when i run the Macro it should ask for the path of the Text file and then convert the content to columns in the excel file.

Thanks in advance,
Ravi

Quote:

---

Originally Posted by ravichandavar

Hi All,

Looking for a macro to Open the text file from a path and convert it to text to Column in excel.
Basically every time when i run the Macro it should ask for the path of the Text file and then convert the content to columns in the excel file.

Thanks in advance,
Ravi

---

Is it possible for you to share the sample txt

Also you can record a macro while doing this manually. Post the recorded code, so that any of us can refine for you.