Importing text files into Excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Christopher Anderson (ChristopherAnderson_at_discussions.microsoft.com)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 15:23:02 -0800

Does anyone know of a quick and easy way to bring large text files into
Excel. The data in the text files is separated by spaces. The spaces that
separate the data vary in number. I have tried to replace the spaces with
tabs while in Notepad but it takes too long. Any help would be appreciated!

Thanks

Chris

Relevant Pages

  • Re: Help formatting rows that are copied/pasted
    ... Not too practical, though, because that would entail pasting and saving the rows to an MS app first, then importing the file. ... We are currently copying/pasting this information to an Excel spreadsheet and manually formatting it (text to columns to separate into columns, copying and adjusting formula rows for totals, disregarding any data that was entered after a specific date, etc.). ...
    (microsoft.public.access.gettingstarted)
  • Re: Simulate Alt+Enter in a table
    ... users miss more than one course, so my code concatenates the course strings ... like using Alt+Enter to separate text while in a table field. ... Works fine until I dump the data to Excel via another proc. ... separate cell, but a separate line within the same cell). ...
    (microsoft.public.access.modulesdaovba)
  • Seeking help from a GURU
    ... When i import the data into excel, everything is put into a separate ... cell. ... like 65,000 of these 13 row blocks. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Word Document
    ... I don't mean having separate ... I'm talking about having one file with several tabs (the same as ... report not several (same as excel). ... or you can use the Window Menu. ...
    (microsoft.public.word.docmanagement)
  • Re: word table convert to excel problem with data converstion
    ... "Suzanne S. Barnhill" wrote: ... That operation will get the separate lines into separate columns. ... The really frustrating thing is that you can insert a line break in Excel ...
    (microsoft.public.word.tables)