From the required data page, Click File |
|||||||
Now click Save As
|
|||||||
Leave File Name the same, and choose My Documents. Now click Save |
|||||||
Now open Microsoft Excel
|
|||||||
Click Data Click External Data Click Import Data |
|||||||
Click My Documents, Click the saved file Click Open
|
|||||||
Check Fixed Width is Checked. |
|||||||
Along the tab bar click in the spaces as shown in diagram
|
|||||||
It should now look something like this. Now Click Next |
|||||||
Leave the next screen as it is and click Finish
|
|||||||
Ensure Existing Worksheet is checked, then Click OK
|
|||||||
Now save this document
|
|||||||
Job Done. |
|||||||