Hi Brian 😉
On 11/14/21 19:08, Brian Barker wrote:
At 11:02 14/11/2021 +0100, you wrote:
how can I have a cell with words in different colors ...
Er, different from what, please?
Different from the normal black, the word "red" in red and the word
"yellow" in yellow
... using a function as in the example attached.
There is no example attached. Attached files are normally removed by
the mailing list processor before messages are distributed.
sorry, I thougt that small calc files was allowed to attach
... in the calc spreadsheet the word in A1 and the word in A2 are
concatenated in A3 with the formula: =CONCATENATE("the magic is ";
A1; " and ";A2) the result I would like to get is in A5
If you want it in A5, why put it in A3?
You probably need to define your problem if anyone is to be able to help.
I trust this helps.
Brian Barker - privately
well, in A1 I have the text "red"
in A2 I have the text "yellow"
in A3 the formula: =CONCATENATE("the magic is "; A1; " and ";A2)
where the result is:
the magic is red and yellow
whee all the words are in black
I would like to have this result:
the magic isred and yellow
where the word "the magic is" is in black, the word "red" inred , the
word "and" is in black and the word "yellow" in yellow
I hope this explanation could be better
manythanks, ciao, pier
P,S, OT, I noted that the nabble platform doesn't work anymore, is it in
use or not?
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy