Hello,
Thanks for contacting us.

Can you please create a sample data in new workbook and try it again?

If the problem persists with the sample workbook, please send it to me.

Please tell me the version information of your Office and computer system.

Thanks in advance.

Split the content from one cell into two or more cells
Select the cell or cells whose contents you want to split. ...
On the Data tab, in the Data Tools group, click Text to Columns. ...
Choose Delimited if it is not already selected, and then click Next.