https://community.hpe.com/t5/operating-system-microsoft/excel-macros/m-p/4244906#M8901 Tools, Macro, Record New Macro, ok<BR /><BR />Data, Import External Data, Import Data<BR /><BR />locate your text file<BR />choose file type of "Fixed width"<BR />set your field widths and data formats<BR />select the destination cells<BR /><BR />Tools, Macro, Stop Recording<BR /><BR />Run the macro, and repeat until you have the desired results<BR /><BR /><BR /> Mon, 04 Aug 2008 07:32:45 GMT Phil.Howell 2008-08-04T07:32:45Z https://community.hpe.com/t5/operating-system-microsoft/excel-macros/m-p/4244905#M8900 Hi,<BR />I want to export data from a notepad(.txt) to an excel sheet, but such that i have some specific columns in the xl sheet already and the data must go into the respective columns and rows. How do i achieve this, can a custom macro be created for this purpose?. Please let me know how this can be done. thanks. Sat, 02 Aug 2008 01:06:20 GMT https://community.hpe.com/t5/operating-system-microsoft/excel-macros/m-p/4244905#M8900 ragavendran 2008-08-02T01:06:20Z https://community.hpe.com/t5/operating-system-microsoft/excel-macros/m-p/4244906#M8901 Tools, Macro, Record New Macro, ok<BR /><BR />Data, Import External Data, Import Data<BR /><BR />locate your text file<BR />choose file type of "Fixed width"<BR />set your field widths and data formats<BR />select the destination cells<BR /><BR />Tools, Macro, Stop Recording<BR /><BR />Run the macro, and repeat until you have the desired results<BR /><BR /><BR /> Mon, 04 Aug 2008 07:32:45 GMT https://community.hpe.com/t5/operating-system-microsoft/excel-macros/m-p/4244906#M8901 Phil.Howell 2008-08-04T07:32:45Z