As Catherine said, the formatting is with the original cell.
If you copy a cell using Ctrl-C or Edit Copy, then pasting it into another
cell (Edit Paste, or Ctrl-V) will retain formatting. In your example it
would be impossible to know which formatting you wanted copied - the italic
or the bold.
If you just want to copy the format of one cell you can copy it and use
Edit Paste Special Format. There is a toolbar button for Paste Format that
you can copy to the toolbar if you do it often.
I dont' know how to preserve the formatting of the separate parts of
concatenated string.
hope this helps anyway
Ruth Callcott
Callcott Consulting Pty Ltd
PO 122,
Mayfield (Newcastle), NSW, 2304, Australia
tel +61-(0)2-4968 3408
fax +61-(0)2-4967 6571
[log in to unmask]
On Tuesday, July 17, 2001 8:49 PM, R. Allan Reese
[SMTP:[log in to unmask]] wrote:
> This is such an obvious bug, I must be missing something.
> If text is copied from one cell to another, it loses the formatting. Can
> the formatting be retained?
> eg
> a1 = "italic text" and is italic (by cell format or as part of the text)
> b1 = "bold text" and is bold
> c1 = +a1&b1 and is plain text. All formatting lost.
|