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 *!! **
    Read Also:

    42

    This website collects cookies to deliver better user experience

    Excel Formulas to Split Text String at Specific Character ~ Easy Tricks!!