Hi!
I have a column containing words in small letters, each word ending in one capital letter.
I would like to have that one capital character in a different style, eg in red, like in the first cell of the image.
I made that first cell manually, but I have many cells to edit, so I would prefer to automate the process.
Is there a way to automatically change the style of all capital letters in the column, with (conditional) styles or macros or something else?
thanks!
Calc hasn’t any standard means to do so.
F&R doesn’t return findings INSIDE any cell, but only the cells containing findings. Therefore you cannot do as if you were working in Writer.
A specialized solution by user code, however, isn’t all too complicated. See attached example.
ask282444VerySpecialTextFormatting_1.ods
(By editing the example was replaced by a slightly better one.)
Paste special (Ctrl+Shift+V) your data as Rich text formatting (RTF) in Writer; this will become a table.
Find All [A-Z], with Regular expressions, and apply style. Then copy and paste in Calc.
Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark (
→ 
) to the left of the answer that solves your question.
If the answer helped you, you can mark the up arrow (
) that is on the left (to vote, you need to have karma of at least 5).
Thank you, I would never have thought of using writer’s capabilities, so that’s a new trick up my sleeve now.Tnx!