Manuals/calci/SPLITTEXT

Revision as of 19:56, 24 May 2017 by Swapna (talk | contribs) (Created page with "<div style="font-size:30px">'''SPLITTEXT(Text, Pattern)'''</div><br/> *<math>Text</math> is a text to split. *<math>Pattern</math> is the pattern with which text is to be spli...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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