Microsoft 77-420 Question Answer
Insert data from a text file.
Cell A1.
File source Autumn.txt
Tab-delimited
Use the following steps to complete this task in explanation:
Step 1:Click cell A1.
Step 2:Click the Data tab, and click the From Text button.
The Text Import Wizard starts.
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.
TESTED 08 Dec 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved