View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Paul Mathews Paul Mathews is offline
external usenet poster
 
Posts: 84
Default Need Help Importing Text File Using Two or More Spaces as the

Jessi, I think you'll still be okay if you start the data at row 4 (where the
date and page number resides) instead of row 10. The vital data itself still
parses okay and you now get the date and page number too (and they're parsed
nicely also:)

" wrote:

Thanks for the suggestions!

I could use a template for my headers and import the data beginning at
row 10... EXCEPT that I need the date and page number that appears on
the second header. Any ideas on how I could still pull that
information into the import?

Thanks again,
Jessi