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! 

Data Science & Business Analytics Courses Duration and Fees

Data Science & Business Analytics programs typically range from a few weeks to several months, with fees varying based on program and institution.

Program NameDurationFees
Applied AI & Data Science

Cohort Starts: 4 Mar, 2024

3 Months$ 2,624
Post Graduate Program in Data Analytics

Cohort Starts: 5 Mar, 2024

8 Months$ 3,749
Caltech Post Graduate Program in Data Science

Cohort Starts: 14 Mar, 2024

11 Months$ 4,500
Post Graduate Program in Data Science

Cohort Starts: 25 Mar, 2024

11 Months$ 4,199
Data Analytics Bootcamp

Cohort Starts: 25 Mar, 2024

6 Months$ 8,500
Data Scientist11 Months$ 2,000
Data Analyst11 Months$ 2,000