Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index

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:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.