Merging and Splitting Cells in Excel: The Best Introduction

In an Excel worksheet, you will sometimes face a situation where you will need to merge or split the cells according to your needs. Merging and splitting is a great way to customize your Excel worksheet. In this article, we will discuss how you can merge or split the cells hasslefree.

Merge Selected Cells

  • Select two or more adjacent cells you want to merge.
  • Click Home > Merge and Center. You can merge cells without centering, click the arrow next to Merge & Center. Then click Merge Across, or Merge Cells.

merge-and-split

  • It then merges the selected cells.

merge2

Become a Data Scientist with Hands-on Training!

Data Scientist Master’s ProgramExplore Program
Become a Data Scientist with Hands-on Training!

Split Selected Cells

Suppose you have three items in a cell separated by a comma. In Excel, there is a tool called Text to Columns. This tool will take columns of cells and separate them into multiple adjacent cells based on a delimiter, which you specify. To split the cells in Excel, execute the following steps: 

Become a Data Scientist with Hands-on Training!

Data Scientist Master’s ProgramExplore Program
Become a Data Scientist with Hands-on Training!
  • Select the cell you want to split.
  • Go to Data tab > Text to Columns.

split1-merge-and-split

  • Select the file data type.

split2

  • Select the Delimiters type. In this case, it is a Comma.

split3

  • Select the Column data format as General and click Finish.

split4

Your data now gets divided into three cells.

split5

Conclusion

So, in this article, we discussed how to split and merge cells in our Excel worksheet. It is a very efficient way to format the cells with ease.

Boost your analytics career with powerful new Microsoft Excel skills by taking the Business Analytics with Excel course (which includes Power BI training) This Business Analytics course teaches you the basic concepts of data analysis and statistics to help data-driven decision making, and also introduces you to Power BI to help you devise insights from available data and present your findings using executive-level dashboards.

Do you have any questions for us regarding this topic? Feel free to ask them in this article’s comments section, and our experts will promptly answer them for you! 

About the Author

SimplilearnSimplilearn

Simplilearn is one of the world’s leading providers of online training for Digital Marketing, Cloud Computing, Project Management, Data Science, IT, Software Development, and many other emerging technologies.

View More

Find Post Graduate Program in Business Analysis in these cities

Post Graduate Program in Business Analysis, Oxford
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, OPM3 and the PMI ATP seal are the registered marks of the Project Management Institute, Inc.