Convert Text from .txt to columns in excel

[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

[erpurohit]

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

[Admin]

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