| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conversion to Text file format error | Excel Discussion (Misc queries) | |||
| Counting occurance of text values across multiple worksheets | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Multiple columns of data saved in a CSV file appears in a single c | Excel Discussion (Misc queries) | |||
| problem working with time data imported from text file | Excel Worksheet Functions | |||
Threaded Mode
