View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lynn Bales Lynn Bales is offline
external usenet poster
 
Posts: 12
Default Single text file imported to multiple worksheets

I have a single text file with many different pieces of data that I'd like
divided into individual worksheets. The text file looks like this:

Server - test1 O/S Version
oracle5 HP-UX B.10.20
oracle7 HP-UX B.10.20
Server - test 2 O/S Version
whmz HP-UX B.10.20
Server - test 3 O/S Version
saturn HP-UX B.11.
oracle5 HP-UX B.10.20
pluto HP-UX B.10.20

As shown each new worksheet would start with the "Server - description"
field. I'd like to have that description also be the tab name if that's
possible.