LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 64
Default Notepad or .txt file to excel

I have a notepad file with thousands of rows of information. I want to copy
it to excel. It copies very well each line into separate rows. But......I
would like......a million dollars......
Is there a way after each space in the notepad file to put that information
in the next column? So I copy information out of notepad into excel and have
the information in separate cells and columns?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why won't Excel open xls file after I saved it with notepad! Kurt[_4_] Excel Discussion (Misc queries) 4 July 15th 09 05:58 PM
Need help converting notepad/txt file to Excel QuestionMan Excel Discussion (Misc queries) 0 February 8th 08 03:41 PM
Need help converting .txt(notepad) file to Excel (2000) QuestionMan Excel Discussion (Misc queries) 1 February 8th 08 12:27 AM
Export notepad file to Excel Carrie Excel Discussion (Misc queries) 2 February 2nd 06 05:36 PM
Filter Notepad file into Excel Rudodoo Excel Worksheet Functions 1 December 1st 05 11:02 PM


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"