I would think you'd have to look at every character in the cell and keep track
of the properties you need to keep track of.

Then copy and paste and apply the properties you want for each character.

=====
Or look at the receiving cell. Make a note of the font size and reapply that
(to the whole cell???) after you copy|paste the funny formatted cell.



ZZBC wrote:

For example:
If a cell contains 4 words "This is a Test" and the word Test is
displayed in a different color and of a different font size ...
with the rest of the string ... how would one copy the contents of that
cell to another cell which is say of a different size, etc. without
changing other properties of that cell?
Bob

--

Dave Peterson