Inquire about Excel functions and formulas.(ChatGPT)
ChatGPT can be used as help on Excel functions and formulas.
Depending on the content, it is often more efficient than searching or using regular help.
Steps
For example, ChatGPT has a question "In Excel, I want to check if a string contains a specified string. Please let me know what functions are available." Type something like.
It will then respond with candidate functions and formulas. For this question, the FIND and SEARCH functions were returned, as well as the ISNUMBER function as an example formula to check.
Below is the full text of the response.
To check if a specified substring is present in a string in Excel, the following functions can be used:
- FIND function: The FIND function searches for a specified text within a string and returns the position of the first occurrence of the text. If the text is not found, the function returns the #VALUE! error.
Example:
=FIND("abc","abcdefg")
Result: 1 (position of "abc" in the string)
- SEARCH function: The SEARCH function is similar to the FIND function in that it searches for a specified text within a string and returns the position of the first occurrence of the text, but it is not case-sensitive. If the text is not found, the function returns the #VALUE! error.
Example:
=SEARCH("abc","aBcdefg")
Result: 1
- Combination of ISNUMBER function and FIND or SEARCH function: The ISNUMBER function returns TRUE if the specified cell contains a number. This can be used in combination with the FIND or SEARCH function to return TRUE if the specified substring is found (which is indicated by the FIND or SEARCH function returning a number).
Example:
=ISNUMBER(FIND("abc","abcdefg"))
Result: TRUE
=ISNUMBER(SEARCH("abc","aBcdefg"))
Result: TRUE
Of the above functions, the FIND and SEARCH functions perform essentially the same function, with the only difference being whether or not they are case-sensitive. Which function to use depends on whether or not case-sensitivity is necessary.
Since ChatGPT's answers are not always accurate, it is necessary to verify the formulas presented by actually using them.