View Single Post
  #3   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Chris,

If using delimited in the Text Import Wizard doesn't work with your text
file (it depends on how it's laid out), you may be able to use "fixed." The
ways of reading a text file into a worksheet vary with the release of Excel.
Check out www.smokeylake.com/excel and read "Excel and text files." There's
a section toward the bottom that deals with reading text files.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Christopher Anderson" wrote
in message ...
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