How to Split Cells Using Excel Formulas in Excel
Step 1: Type Header text “Product” and “Category” to cells B1 and C1 respectively
Step 2: Write the below formula in cell B2 to split the first word (Product)
=LEFT(A2,FIND(” “,A2)-1)
Step 3: Fill the formula in cells B2:B11
Step 4: Write the below formula in cell C2 to split the last word (Category)
=RIGHT(A2,LEN(A2)-FIND(” “,A2))
Step 5: Fill the formula in cells C2:C11
How to Split Cells in Excel: In 5 Easy Steps
Microsoft Excel is a powerful data tool used in various industries. Organizing data in separate cells is crucial for clarity and analysis. We often receive data with many points in one cell due to different initial purposes.
In these situations, we frequently divide a cell into its component pieces. In this article, we will learn how to split cells in Excel using formulas, shortcut Keys, and more.
Contact Us