Before I ask question, I've searched but only found ways of copy and paste "formatted cell". That's not what I need.
I want to use an example to explain my requirement:
- There are 2 cells in a sheet.
- Cell_A's text is "aaaaabbbbb", and "aaaaa" is green, and "bbbbb" is red.
- Cell_B's text is "ccccc" and "ccccc" is black.
- I want to copy and paste "bbbbb" from Cell_A to Cell_B and keep "bbbbb" in red. But in my environment(Office 2007), "bbbbb" is changed to black as "ccccc", the default format of Cell_B.
Is there an easy way to implement my requirement?