Join Text: JoinText.SK is used to append text strings within a range of cells into a single string while using some delimiter.
Contains Text: This function is used to check whether the provided text contains a given subtext.
Text to Columns: This function is used to separate the contents of excel cell into separate columns
REGEX Functions: A regular expression (shortened as regex or regexp also referred to as rational expression) is a sequence of characters that define a search pattern. Usually such patterns are used by string-searching algorithms for "find" or "find and replace" operations on strings.