V vj1030 New Member Jan 2, 2012 #1 hi i have got one file from my supplier, this issues is i was supposed to get the report on xl format but unfortunately he sent in .txt file type i need to know how can this b converted?
hi i have got one file from my supplier, this issues is i was supposed to get the report on xl format but unfortunately he sent in .txt file type i need to know how can this b converted?
Hui Excel Ninja Staff member Jan 2, 2012 #2 VJ1030 Goto: File, Open Change file type to Text File (*.prn, *.csv, *.txt) The Text Import Wizard will start Depending on the layout of your file go through the various options as a Delimited or Fixed Column Width File
VJ1030 Goto: File, Open Change file type to Text File (*.prn, *.csv, *.txt) The Text Import Wizard will start Depending on the layout of your file go through the various options as a Delimited or Fixed Column Width File
