| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get font of particulat word in text inside a cell?
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!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get font of particulat word in text inside a cell?
A string is just a string; no formatting is attached. How do you get a
partially bold string for: abc = "i am a man" /* man is bolded originally ? -- Vasant "Laguna" wrote in message ... 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!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get font of particulat word in text inside a cell?
Copy and paste the cell and then remove the end of the copied cell's
value - if you really meant "Left()" Tim. "Laguna" wrote in message ... 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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference text in a cell inside a formula to specify a sheet name | Excel Worksheet Functions | |||
| I NEED TO CAPITIALIZE MY TEXT INSIDE THE CELL...HOW? | Excel Discussion (Misc queries) | |||
| counting text example of a cell with multiple words inside | Excel Discussion (Misc queries) | |||
| How do I insert a new line of text inside a cell | New Users to Excel | |||
| Text Font Selection Inside Combo Box | Excel Programming | |||
Linear Mode
