From ZCubes Wiki
Revision as of 03:58, 25 May 2017 by Swapna (talk | contribs) (→‎See Also)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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