Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Split Text from One Cell into Multiple Cells in Excel

Date:2020-1-5 Author:Cordelia

Sometimes you copy some texts to Excel with the intention of splitting them into multiple columns, but it turns out that all the texts were put into the same column. To rearrange them manually is a heavy work. So how could you split the content into two or more cells in Excel without cutting and pasting one by one?

1. First, select the cells in Excel.

How to Split Text from One Cell into Multiple Cells in Excel

2. Go to Data tab and click Text to Columns.

How to Split Text from One Cell into Multiple Cells in Excel

3. In my case, I choose Fixed width. But if you have some obvious marks as the separation of two columns such as commas and tabs, you better choose Delimited.

How to Split Text from One Cell into Multiple Cells in Excel

4. Hit Next. Here you can click the Data preview section to create a cursor, and drag it to separate the content as you need.

How to Split Text from One Cell into Multiple Cells in Excel

5. If you want to divide one column into three, then add two cursors to separate it. If you don’t want one of the cursors, drag it out of the area of Data preview.

How to Split Text from One Cell into Multiple Cells in Excel

6. Set the data format as you need. Click Finish to apply it to your Excel file.

How to Split Text from One Cell into Multiple Cells in Excel

7. Now the content has been divided into three columns.

How to Split Text from One Cell into Multiple Cells in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *