almost 6 years ago
I need to import data from a website, Like a Website ( http://ss64.com/nt/ ), which provide list of commands and their description.
I want these command and description can directly import to my local LibreOffice Calc Sheet columns seprately.
I already search on internet but most of Tuts and QandA only Showing the method for MS Office. Like this website: http://www.internet4classrooms.com/excel_import.htm.
Can anybody help me out. Any step by step explanation on this issue is much appreciated.
In continuation to my answer, here's something useful and fun:
Copy the following formula in cell B1 (assuming your data starts in A1): SUBSTITUTE(TRIM(A1)," ","*",1)
Copy down the above formula to the rest of the cells
Select column B
Go to Data--> Text to column...
Check "Other" and put "*" there (without double quotes)
Your Data should be split and formatted in a nice usable table.
Hi Sir ( @nitin.joshi)
Thanks you so much sir for the step by step and detail explanation. Few hours back it is tough task, Now It is looking easier now.
Thanks you once again
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using