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

Business Analyst Master's Program

Gain expertise in Business analytics toolsExplore Program
Business Analyst Master's Program

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: 

FREE Course: Introduction to Data Analytics

Mastery to Data Analytics Basics is a Click Away!Start Learning
FREE Course: Introduction to Data Analytics

  • 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

Gain expertise in the latest Business analytics tools and techniques with the Business Analyst Master's Program. Enroll now!

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 certification 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
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.