excel - 如何检查单元格是否包含通配符星号 (*) 字符

Question

考虑以下两个公式:

=IF(SEARCH("*", A1), "true", "false")

=IF(SEARCH(CHAR(42), A1), "true", "false")

我使用它来尝试检测单元格是否包含 * 字符，但这对所有单元格返回“true”。我只能假设 Excel 将 * 视为通配符。

如何检测 Excel 中是否存在 *？

Answer 1

根据microsoft的引用你应该能够使用 ~

Microsoft Excel uses the tilde (~) as a marker to indicate that the next character is a literal. When you use the Find and Replace dialog box to find or replace a character such as a tilde (~), an asterisk (*), or a question mark (?), you must add a tilde (~) before the character in the Find what box.

因此将 =IF(SEARCH("*", A1), "true", "false") 更改为 =IF(SEARCH("~*", A1), "true", "false") 它应该可以工作。