Replaces specified text within a string with new text.
Extracts a portion of a text string.
Extracts a substring from the start of a designated text.
Switches the arrangement of rows and columns in a specified array or cell range.
Consolidates all values from one or multiple ranges into a singular column.