Microsoft
77-420 · Question #29
Insert data from a text file. Cell A1. File source Autumn.txt Tab-delimited
Step 1: Click cell A1. Step 2: Click the Data tab, and click the From Text button. Step 3: Make sure Delimited is select, and click Next. Step 4: Make sure Delimiters: Tab is selected. Then click Next. Step 5: Finish the wizard by click the Finish Button. Step 6: Confirm with…
Manage Data Cells and Ranges
Question
Insert data from a text file. Cell A1. File source Autumn.txt Tab-delimited
Explanation
Step 1: Click cell A1. Step 2: Click the Data tab, and click the From Text button. Step 3: Make sure Delimited is select, and click Next. Step 4: Make sure Delimiters: Tab is selected. Then click Next. Step 5: Finish the wizard by click the Finish Button. Step 6: Confirm with OK in the Import Data dialog box.
Topics
#import text file#tab-delimited data#external data#data import
Community Discussion
No community discussion yet for this question.