20
Excel Formulas to Split Text String at Specific Character ~ Easy Tricks!!
Have you ever tried to split the text string based on a specific character in Excel? Here we will show the formulas to solve this problem in a quick way. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
- You can use the below formula to split the text string based on a specific character in Excel.
1st String
2nd String
- LEFT – It extracts the first character (starting from the left side) or characters from the given string based on the number you specified. Read more on the LEFT function.
- RIGHT – The RIGHT function is used to extract the texts with the given number of characters from the right side.
- LEN – This function helps to return the length of a given text string as the number of characters. Read more on the LEN function.
- MID – This function helps to return the smallest numeric value from the range of input values. Read more on the MID function.
- FIND – In Excel, the FIND function is used to find out the one text string inside the other.
- Text – It represents the input value.
- Character – It specifies the input character.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Let’s consider the below example image.
- First, we will enter the input values in Column B.
- Here we need to split the text string based on a specific character.
- Select any cell and type the above-given formula.
- Finally, press the ** ENTER** key, you can get the result as shown below.
Hope you like this article on how to split the text string based on a specific character in Excel. Let me know if you have any doubts regarding this article or any other Excel/VBA topic.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
20