P pea33nut Member Dec 25, 2004 61 0 0 Apr 11, 2005 #1 I am trying to convert a notepad file to excel. How can I make this convertion so that my columns line up. Right now my data is pretty ugly looking. Hope you guys can help me!!!!!!!! Thanks
I am trying to convert a notepad file to excel. How can I make this convertion so that my columns line up. Right now my data is pretty ugly looking. Hope you guys can help me!!!!!!!! Thanks
BlueWeasel Lifer Jun 2, 2000 15,944 475 126 Apr 11, 2005 #2 How are the columns separated in Notepad (ie, tabs, commas, etc)?
N NeoV Diamond Member Apr 18, 2000 9,504 2 81 Apr 11, 2005 #3 save it as a comma delimited file (csv) open in Excel, go to Data, Text to Columns good to go