I have a 5000 rows in Libreoffice calc file and the data have issue, It is a multi line cell So I need the extracted data to be in one line separated with commas in the next cell.
Below a cell of the file:
Law: Patents, Trademarks, CopyrightCertificates, Diplomas, Licenses, CVs
Law (general)Finance (general)
Also I need the words like EconomicsLaw to be corrected, Any one have an idea?
My question is finished.
Note: While searching, I found a file from a respected person but it was corrupted. But I selected the full sheet cells and pasted as html 111111.xlsx . If I can increase the results as I need, This would be great.
The corrupted file is here :13919944284536718.ods