gpt4 book ai didi

excel - 为什么这个excel字符串比较返回失败?

转载 作者:行者123 更新时间:2023-12-04 21:03:20 24 4
gpt4 key购买 nike

它是一个 Excel 错误吗?有谁遇到过这个问题,请帮忙?

EXCEL BUG

最佳答案

只是一个想法,但这就是 MS 对 TRIM 的评价

The TRIM function was designed to trim the 7-bit ASCII space character (value 32) from text. In the Unicode character set, there is an additional space character called the nonbreaking space character that has a decimal value of 160. This character is commonly used in Web pages as the HTML entity,  . By itself, the TRIM function does not remove this nonbreaking space character.



你可以试试这个来替换不间断的空间(如果这是你的问题)。
=TRIM(SUBSTITUTE(A5,CHAR(160),CHAR(32))) 

关于excel - 为什么这个excel字符串比较返回失败?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/31275310/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com