A TEXT IMPORT WIZARD box will open prompting you to select how you want the data to appear when viewed using excel.Highlight the filename you want to open and click OPEN.Hint: If you do not see the file you saved listed, change the TYPE of file that is displayed to ALL FILES.Click on FILE -> OPEN (or use the icon button).Accept the default file name or change it, but be sure to select FILE TYPE – Text File (.txt) from the options available in the scroll menu.Click on the FILE menu, top left corner of window.If the data table is in a Word document or in text format on a webpage, change its format by saving the file/page as a text file.
An example of a web address that ends in. Word documents can be converted into text-only format. Import tables into Excel from a text file (.txt)Ī flat text file may be displayed on a web browser.
0 kommentar(er)
