I have known that we can get the font,bold, size for whole text in a cell
but after doing string operation
eg.
abc = "i am a man" /* man is bolded originally
abc = Left(abc, 3), the original bold

when I copy the string "abc" to another cell
it lost the bolded format


I am using excel 2000 VBA
how to preserve the font style when doing copy and string operation?

thank you for your help!!