Hi,
I have 2 columns in my sheet, and to save on white space when printing I decided to merge them togheter and play with the markup factor .
minimalistic example of my situation with random ages and names, not everyone has a specified age like so :
...
12 Jon
Dean
Phill
45 Megan
Portia
...
The formula for the new column is simple =IF(ISBLANK(A1),B1,B1&" "&A1)
.
Now the problem is : how I can formulate the conditional such that when mergin the content of A in B, the content of A gets different formatting, like for example, B keeps being a plain regular font and A is italic .
I haven’t found any reference to this kind of operations inside the libreoffice documentation .
I would also like to know how to make the result of a formula “permanent” so that I can delete the old columns from the sheet .
Thanks .