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

Generic Formula:

You can use the below formula to split the text string based on a specific character in Excel.

1st String

=LEFT(text,FIND(character,text)-1)

2nd String

=RIGHT(text,LEN(text)-FIND(character,text))

Syntax Explanations:

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.

Practical Example:

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.

Bottom-Line:

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 *!! **