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.

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

Read Also:

Excel Formulas to Replace One Character with Another ~ Quickly!!

How to Validate Only Numbers in Cell in Excel Office 365?

Excel Formulas to Replace One Character with Another ~ Quickly!!

How to Search for a Value in All Tabs in Excel Office 365?