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
AAAA"Content of cell B1: =SUBSTITUTE(TEXT(A1;"NNNNJ MMMM
AAAA");REGEX(TEXT(A1;"NNNNJ MMMM AAAA");"[a-
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 126.96.36.199 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?
To unsubscribe e-mail to: email@example.com
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