gpt4 book ai didi

excel - 用于文本(、格式)转换的嵌套字符串

转载 作者:行者123 更新时间:2023-12-03 03:23:17 26 4
gpt4 key购买 nike

如何将 Text() 与内部包含字符串的格式一起使用?

=TEXT(A1,"Comfi+"#0"(JO)";"Comfi-"#0"(JO)")

尝试了“””两个内部字符串:

 =TEXT(A1," """Comfi+"""#0"""(JO)""";"""Comfi-"""#0"(JO)""" ")

与 &char(34)& 的结果相同

这里有类似的问题,但我无法将解决方案转换为我的问题:How to create strings containing double quotes in Excel formulas?

Post Solution edit :

Building an almanac/calendar with the following (now fixed)formula :

=CONCATENATE(
TEXT(Format!K25,"d"),
" J+",
Format!S25,
" ",
TEXT(Format!AA25,"""Comfi+""#0""(JO)"";""Comfi-""#0""(JO)"""),
" ",
Format!AI25
)

Giving the following output in each cell :

           9
J+70
Comfi+21(JO)
CRG

最佳答案

里面有太多引号:

=TEXT(A1,"""Comfi+""#0""(JO)"";""Comfi-""#0""(JO)""")

您将许多内部引号增加了两倍。

enter image description here

关于excel - 用于文本(、格式)转换的嵌套字符串,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/49150546/

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