Home > IT Answers > Business Intelligence > Conversion of text file from Notepad to Microsoft Excel
Govind27
5 pts.
 Conversion of text file from Notepad to Microsoft Excel
File conversion, Microsoft Excel import/export, Notepad
I have data in rows in a note pad without separators. How to convert these into columns in a excel file

Software/Hardware used:
ASKED: June 10, 2009  10:48 AM
UPDATED: June 10, 2009  12:57 PM
RELATED QUESTIONS
Answer Wiki:
Excel has a Text to Columns function under the Data menu item. It will permit you to parse out a text file into columns based on fixed length or delimiters. See this <a href="http://www.worldstart.com/tips/tips.php/1153">tip for an example</a> or watch <a href="http://www.youtube.com/watch?v=y17NLIoDqtg">this video on YouTube</a> for additional information. In the IT trenches? So am I - read my <a href="http://itknowledgeexchange.techtarget.com/it-trenches">IT-Trenches blog</a>
Last Wiki Answer Submitted:  June 10, 2009  12:56 pm  by  Labnuke99   32,630 pts.
All Answer Wiki Contributors:  Labnuke99   32,630 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _