Manuals/calci/SPLITTEXT

SPLITTEXT(Text, Pattern)


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

Description

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


Examples

  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

References