Split Text to Column in Excel in Java | https://blog.aspose.com/2021/05/25/split-text-to-columns-in-excel-using-java/

text-to-column.java

// Open a workbook.
Workbook wb = new Workbook("workbook.xlsx");
	  
// Access first worksheet.
Worksheet ws = wb.getWorksheets().get(0);
		  
// Add people name in column A. Fast name and Last name are separated by space.
ws.getCells().get("A1").putValue("John Teal");
ws.getCells().get("A2").putValue("Peter Graham");
ws.getCells().get("A3").putValue("Brady Cortez");
ws.getCells().get("A4").putValue("Mack Nick");
ws.getCells().get("A5").putValue("Hsu Lee");
		  
// Create text load options with space as separator.
TxtLoadOptions opts = new TxtLoadOptions();
opts.setSeparator(' ');
	  
// Split the column A into two columns using TextToColumns() method.
// Now column A will have first name and column B will have second name.
ws.getCells().textToColumns(0, 0, 5, opts);
		  
// Save the workbook in xlsx format.
wb.save("TextToColumns.xlsx");

Read the article: https://blog.aspose.com/2021/05/25/split-text-to-columns-in-excel-using-java/