Which function looks for a specific character within a text string?

The function designed specifically to locate a specific character or substring within a text string is FIND(). This function allows you to search for a character, and it is case-sensitive, meaning that it distinguishes between uppercase and lowercase letters. It returns the position of the first occurrence of the specified character, enabling users to determine where in the string the character appears.

By contrast, SEARCH() also locates characters within text but is not case-sensitive, which can lead to different results based on the input. The LEFT() function, instead, extracts a specified number of characters from the beginning of a text string, unrelated to searching for characters. TEXT() serves a different purpose, which involves formatting numbers as text, rather than finding or searching for characters. Understanding these distinctions clarifies why FIND() is the appropriate choice for locating a specific character within a text string.