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.
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.
Page :
1
There are no replies made for this post yet.
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »