Hi all,
I'm struggling to format strings into a cell

this string is a concatenation of other substring, something like this:

=CONCATENATE("substring 1 ";" or substring 2  ";CODE.CHAR(10);TEXT(C30;"0,00%");" substring 3")
I would like to format one or more substring, choosing if bold, or italic, or the font colour...

but honestly I'm looking the web since lot of time and found anything for the time being...

do you know if it's possible?

thanks!