- 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.
- SPLITTEXT("Have a nice day","a") = H ve nice d y
- SPLITTEXT("Congratulations","t") = Congra ula ions
- SPLITTEXT("What is your name?"," ") = What is your name?