| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting .txt File
I have imported a txt file into Excel and there are five txt fields that are
all contained within one xls field. The txt data has several spaces in between the fields. Is there a way to assign the txt fields to different xls fields? -- Gator |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting .txt File
Try using TEXT TO COLUMNS on the Data menu.
-- Kevin Backmann "Gator" wrote: I have imported a txt file into Excel and there are five txt fields that are all contained within one xls field. The txt data has several spaces in between the fields. Is there a way to assign the txt fields to different xls fields? -- Gator |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting is change after saving .csv file | Excel Discussion (Misc queries) | |||
| Re-formatting when saving as HTM file. | Excel Discussion (Misc queries) | |||
| Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
| excel formatting to text file | Setting up and Configuration of Excel | |||
| Formatting of Data from .CSV file | Excel Worksheet Functions | |||
Linear Mode
