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.