Friends,
I have several cells with text that contains in-cell formatting, like first word is in font A and second word is in font B. How can I combine/concat these cells into one cell while keeping the formatting?
Cell A1: <font times>Foo</font> <font sans>bar</font>
Cell B1: <font typewriter>Baz</font>
Required result:
Cell C1: =concat-with-formatting(A1;B1)
=> <font times>Foo</font> <font sans>bar</font><font typewriter>Baz</font>
Thanks for any hint!
You can’t do that using formulas. Your only way is macros.
Thank you, I was suspecting this already. Would be great if we could as I find this a very common task.
Excel users have been asking for this feature for over 30 years (since the first versions). 
If a cell contains a formula and its value is recalculated several times, how can we set a rule to format part of the cell?
With macros we can (theoretically) do this by listening for changes in cells A1 and B1.
Just re-concat again? (But I’m certainly in no position to comment any developers expertise here - I’m sure there’'s a good reason if it’s not available.)
Here are two OpenOffice threads for format a text character-by-character (is is possible by a macro (by usage direct formatting merthod)):
https://forum.openoffice.org/en/forum/viewtopic.php?p=505226#p505226
https://forum.openoffice.org/en/forum/viewtopic.php?f=7&t=77844