Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Nested strings for text(,format) conversion

How do you use Text() with a format that has a string inside it ?

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

Tried """ both the inner string :

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

Same result with &char(34)&

Similar issue here, but I couldn't transpose the solution to my problem : 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
like image 842
Adav Avatar asked Dec 11 '25 18:12

Adav


1 Answers

You've got too many quotation marks inside:

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

You were tripling many of the inside quotation marks.

enter image description here

like image 60
Ron Rosenfeld Avatar answered Dec 14 '25 10:12

Ron Rosenfeld



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!