From ZCubes Wiki
Jump to navigation Jump to search
SPLITTEXT(Text, Pattern)

  • is a text to split.
  • is the pattern with which text is to be split.


  • This function returns the text in split characters with specified pattern.
  • and should be entered in double quotation marks.


  1. SPLITTEXT("Have a nice day","a") = H ve nice d y
  2. SPLITTEXT("Congratulations","t") = Congra ula ions
  3. SPLITTEXT("What is your name?"," ") = What is your name?

Related Videos

Split a String

See Also