Text to Column in Excel using Python | https://blog.aspose.com/2021/06/24/split-text-to-column-in-excel-using-python/

text-to-column.py

# Open Workbook
workbook = Workbook("workbook.xlsx")

# Access the first worksheet
worksheet = workbook.getWorksheets().get(0)

# Add people name in column A. Fast name and Last name are separated by space.
worksheet.getCells().get("A1").putValue("John Teal")
worksheet.getCells().get("A2").putValue("Peter Graham")
worksheet.getCells().get("A3").putValue("Brady Cortez")
worksheet.getCells().get("A4").putValue("Mack Nick")
worksheet.getCells().get("A5").putValue("Hsu Lee")

# Create text load options with space as separator.
txtLoadOptions = TxtLoadOptions()
txtLoadOptions.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.
worksheet.getCells().textToColumns(0, 0, 5, txtLoadOptions)

# Save the excel file.
workbook.save("TextToColumns.xlsx")

Read the article: https://blog.aspose.com/2021/06/24/split-text-to-column-in-excel-using-python/