Page 174 - Computer - 10(A&B)

Step 2: Now, open a new Calc worksheet and choose SheetExternal links. The External Data dialog box will
open.

Step 3: Enter the URL or the file name that contains the data that you want to insert, and then press the Enter
key. Alternatively, click on Browse button to select the file name.
Step 4: The Insert dialog box will open. Select the text file we created earlier and press the Open button.
Step 5: The Text Import dialog box appears. Specify separators to be used under Separator Options.

Separator just means what character is being used to separate each value which in this case is a space.
You can use tab spaces, semicolons, or commas to separate each value, in the text file.

56