This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
All the excels have the data in the first column using semi colon as delimiter as seen above.
I can format the excel using the Data -> Text to Column -> Delimited(Selecting Semicolon as the delimiter) and then saving the formatted excel. This procedure puts the semicolon seperated values in different columns as needed.
However,I have a few thousands excel sheets to be formatted.This is not very convenient thing to be performed manually.
I was wondering if this can be done using Java code.