Which function assumes the first occurrence when left blank?

The TextBetween function is designed to extract text from a string based on specified start and end delimiters. When the function is called with its optional parameters left blank, it defaults to the first occurrence of the specified delimiters within the string. This behavior ensures that if a user does not specify where exactly to start looking for the text or where to stop, the function will automatically focus on the first match it encounters.

In practical terms, this means that if you are analyzing data and want to extract a substring, using TextBetween with any of its parameters left blank guarantees simplicity and consistency, as it will always return the first valid segment between the defined boundaries. This can be particularly useful in cases where the data format may vary, but the first occurrence holds particular significance or is the desired target for analysis.

Other functions like Replace, Capitalize, or Mid have different purposes or do not inherently default to the first occurrence in the same way when parameters are left blank.