At 16:24 29/06/2009 -0500, Zhengquan Zhang wrote:
I have got a column of cells which contains contents like:
sentence(explanation);
the fonts in and out of the parenthesis are the same, both are aria
12; Now I would like to change the fonts in the parenthesis(the
explanation part) to italics and to smaller fonts, say aria 11.
I don't know that you can do this easily within Calc, but here's a workaround:
o Copy the column of cells.
o Paste into a text (Writer) document, using Paste Special and
"Unformatted text".
o Using Find & Replace, with "Regular expressions" ticked, search
for \((.*)\) and replace with (#$1#) .
o Using Find & Replace again, still with "Regular expressions"
ticked, search for #(.*)# and replace with $1 . This time, put the
cursor into the "Replace with" box and click the Format button; then
choose your new text format: Arial 11pt italic?
o Copy the material back into your spreadsheet, setting the cell
format to Arial 12pt.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
