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

I do not know how to achieve what you are looking for directly.
However, you can use something like this, supposing you want to display
the date of January 21, 2020:
Content of call A1: =DATE(2020;1;21) - cell format is "NNNNJ MMMM
z]");UPPER(REGEX(TEXT(A1;"NNNNJ MMMM AAAA");"[a-z]"));1)Content of cell
C1: =SUBSTITUTE(B1;REGEX(B1;" [a-z]");UPPER(REGEX(B1;" [a-z]"));1)
The example above uses English function names but I normally use the
French localization. In my version (6.3), this is what comes out:
Display of A1: mardi 21 janvier 2020Display of B1: Mardi 21 janvier
2020Display of C1: Mardi 21 Janvier 2020
Just make sure the second SUBSTITUTE (cell C1) has the two REGEX
looking for "space[a-z]" and not just "[a-z]". The downside of this
approach is you need to use two additional columns (you can hide them),
or make a complicated formula that merges what I have in B1 and C1.
I hope this helps.

Le mercredi 22 janvier 2020 à 14:23 -0700, TheJoe a écrit :
Hi,I have a small issue that i could not solve. First of all i'm
sorry for mybad English... i'm Italian.
I'm using LibreOffice with Italian localization.
I'm trying to format a date in Calc... What i'm getting right now
is:lunedì 2 settembre 2024
I would like instead to have every word starting with a capitali
letter:Lunedì 2 Settembre 2024
Also "Format" - "Text" - "CAPITALS" doesn't work.
The thing i don't want to do is reformat the cell to text (it must be
Do you think it's possible?

--Sent from:

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.