How to Split Cells in Excel Using Text Functions in Excel
There are many Text Functions in Excel, but we don’t need all of them here. A few of them are mentioned below:
- LEN- Returns the length of a String.
- RIGHT– Extract a specified number of characters from a String’s right end.
- LEFT- Extract a specified number of characters from a String’s left end.
- FIND– Look for a string inside another string.
- SEARCH– Return the positions of a string inside another string.
- MID– Extract a specified number of characters from a String’s center.
You can use any combination of the above text Functions to achieve your split.
Enter the Formula =LEFT(A2,SEARCH(" ",A2)-1) in cell B2.
The SEARCH looks for any space in the customer name and returns its position in the string. Then, the LEFT function extracts the part of the String from the left side, up to the position returned by the SEARCH Function.
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